DAX Formula

Resolved · Low Priority · Version 2016

Wed 23 Oct 2019, 10:07 Delegate Lesley said...

Lesley has attended:
Power BI Modelling, Visualisation and Publishing course
Power BI DAX course

DAX Formula

Hi, I am using the below formula to work out if an employee has submitted multiple expense claims by using their supplier number:

Count of Employee ID = IF(COUNT(OA_EXPENSES_PAYMENTS_VW[SUPPLIER_NUMBER])<1.5,"SINGLE CLAIM","MULTIPLE CLAIM")

I also need a count of how many expense claims each person has submitted, can you please help with this.

Wed 23 Oct 2019, 17:18 Trainer Jens said...

RE: DAX Formula

Hi Lesley,

Thank you for the forum question.

Do you have a table with the employees (one record for each employee) and a related table with the claims? Or how have you the data organised?

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 8 Nov 2019, 09:37 Trainer Claire said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Fri 15 Nov 2019: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Power BI tip:

Master the Power BI Custom Visuals

Power BI offers a variety of custom visuals created by the community and Microsoft. Explore these visuals to enhance your reports and dashboards. Whether it's a custom map, a timeline, or a unique chart type, custom visuals can add significant value to your visualizations.

View all Power BI hints and tips