Human Resources Sample File - Sample%ofActive Total shows different values in different visuals

[MaggieWang]

My query relates to Human Resource sample file for Power BI. I set a filter on Year 2014. I then plot measure Sep%ofActive (in Employee table) and Period (in Data table) into a waterfall visual. The total shown in this graph says 51.7%. When the same measure if plotted into a Card visual (without Period), it shows 48.99%. Why the tatals shown in these two visuals are different, even though I am plotting the same measure? Many thanks.

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks

[MaggieWang]

Thank you @amitchandak . I  don't seem to be able to attach a file but the sample pbix file is provided on this tutorial page https://docs.microsoft.com/en-us/power-bi/sample-human-resources.

[amitchandak]

Please share formula of Sep%Active and formula of any measure used in it

[MaggieWang]

Thank you. Here are formulas used in these measures:

Apologies, I don't seem to be able to copy and paste these formulas so had to load in as an image.

[amitchandak]

Is the chart is on Sep%OfActive.

Check out the impact select of the year on Sep%OfActive. I doubt it is changing. (Either active or Sep should have additional relationship clause )

Can also share screen short relation. OR Send me Link to download pbix from the location you shared. I checked but did not get pbix download link.

[MaggieWang]

Thank you. I selected year 2013 and the inconsistancy persists.

Please find below a link to the sample workbook.

Human resources sample file 

[v-xicai · Accepted solution]

Hi @MaggieWang ,

You might add ALLSELECTED function to take effect of slicer filter in the formula [Actives] as follows.

Actives = CALCULATE([EmpCount], FILTER(ALLSELECTED(Employee), ISBLANK(Employee[TermDate])))

Result:

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MaggieWang]

Hi Amy @v-xicai , thank you so much for your help, your solution works like magic! I have been struggling with this problem for weeks and am truly grateful for your help. It is by far the best Christmas present for me! Once again thank you..