Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
sixathur
Frequent Visitor

Multiple DAX measure issues

Hi,

I am trying to create a Bonus calculator for my report,

Measure 1: Total Visits (I counted all the rows in the report to get the total visits)

IMG_7722.png

 

 

 

Measure 2: PTO Hours ( I sum all the PTO hours)

IMG_7721.png

Measure 3: FTE - I need to calculate the FTE per employee, 40 hours is full-time hours, from there I need to calculate the Target Visits

IMG_7723.png

Measure 3: Target Visits - 58 is the default visit for a full time employee (1 FTE), this measure should calculate the visit targer based on their FTE

 IMG_7720.png

Measure 4: Bonus - if the Total visits is higher than the visit target, get the difference then multiply by 15.

IMG_7724.png

Issue: The main issue I am having with all these formula is when I calculate the Estimated Bonus, its giving me the total visits multiply by 15, if I use the slicer (date) it gives me the correct data but without any filters its totalling all the visits. 

 

What am I doing wrong? I really need help.

7 REPLIES 7
v-echaithra
Community Support
Community Support

Hi @sixathur ,

We would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

 

Regards,
Chaithra.



v-echaithra
Community Support
Community Support

Hi @sixathur ,

May I ask if you have gotten this issue resolved?

 

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

 

Regards,
Chaithra.

v-echaithra
Community Support
Community Support

Hi @sixathur ,

We would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

 

Regards,
Chaithra.

Anonymous
Not applicable

Hi @sixathur 

 

I'd recommend putting these measures all in the same table visual, and then using the slicer to pick dates to see which measure might not return the correct value in some specific cases. From the current information, if the Estimated Bonus gives you the total visits multiply by 15, it means VisitTarget might return 0 at the same time. 

 

Best Regards,
Jing

some_bih
Super User
Super User

Hi @sixathur it is hard to spot issue/s without your model. CALCULATE  is used to modify filter context so please provide some sample file with data input and expected output.

It could be something like relationship, or need to adjust your measures with SELECTEDVALUE for targeted filter context.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






626C955A-D853-43A4-A7E9-ED74B7847303.jpeg

Hi, 

this is my model.

Hi @sixathur I could not see on picture your tables named in measures above, like

some_bih_0-1742197970654.png

some_bih_1-1742197985922.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.