Visual displaying inaccurate information

[Naomig2088]

I have a card visual displaying a measure. The measure (measure c) uses two other measures (measure a and measure b) make the calculation- these are displaying accurate information but measure c is not. How can this be?

[Naomig2088]

I think I've made some progress as to why it's producing the incorrect info, but don't know how to fix it.

The filters on the card visuals in the steps leading up to C are correct as they produce the correct outcome. However, these filters conflict with each other when applied to C.

So, in order to calculate Available Working Days I only need date filters, not the Leave Type Filter which is applied to the Days Lost Visual. 

How is it possible to create a visual if the filters on the previous steps are in conflict?

Any help much appreciated!!!

[Greg_Deckler]

@Naomig2088 Could be a measure totals issue. First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

Otherwise, Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Naomig2088]

Thanks for your reply.

I think it might be a filter issue...

I have applied the same filters to the card showing measure c as measures a and b but the result is not accurate.

Should the filters on all visuals be the same?

Many thanks.

[jennratten]

There could be other elements on the page playing into the filter context and impacting the visuals in an unexpected way.  I find it helpful to sometimes add a new blank page to the report, then copy only the problematic visual to the blank page and see if the result is the same.  That will usually quickly determine whether some filter context or visual interaction is the cause and can reveal the actions needed to resolve the issue.

[Naomig2088]

to add further confusion...

B is 

AvailableWorkingDays = [NumberWorkers]*[Workdays]

This is driven by Workdays, which uses the formula:

Workdays = CALCULATE(SUM('Calendar Table'[Workday]))

and NumberWorkers, which uses the formula:

NumberWorkers = CALCULATE(COUNT(PositionsV2[WorkerPersonnelNumber]))

The number of workdays is always 262 as it is the number of working days in the last 12 months.

When the number of workers is 1 and so calculation B is

AvailableWorkingDays = [NumberWorkers]*[Workdays]

262=[1]*[262]

then C

%DaysLost = ([DaysLost]/[AvailableWorkingDays])

is calculating correctly.....

[Naomig2088]

Thank you- I've done this and the result is the same

it's so confusing!

[Anonymous]

Hi @Naomig2088 ,

Context in Power BI can greatly affect the results of your calculations. 
Could you consider sharing the A,B,C code? Sample data and expected output would be great.
How to provide sample data in the Power BI Forum

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[Naomig2088]

Hi,

A is 

DaysLost = (SUM(LeaveRequestsV2[Total Amount]))

This is the visual:

This is the expected output.

B is 

AvailableWorkingDays = [NumberWorkers]*[Workdays]

The visual is 

This is the expected outcome.

C is 

%DaysLost = ([DaysLost]/[AvailableWorkingDays])

The visual is

which is not correct....

Any help, much appreciated.

Thank you.