Forum Discussion
Human Resources Sample File - Sample%ofActive Total shows different values in different visuals
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.
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.
8 Replies
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.
ThanksThank 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.
Please share formula of Sep%Active and formula of any measure used in it
