Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to be able to divide Field A(filtered by Date) by Field A(filtered by Code).
Field A filtered by date gives me 319 records, Field A futher filtered by Code, gives me 282 records of the original 319.
I need to work out the percentage e.g. 282/319 = 88%
How do I do this? I have tried measure, quick measure and column and are receiving a result of 1 or 100% - it is assuming the Field result is the same even though I have created two separate measures for the difference in filtering.
Help please.
Solved! Go to Solution.
hi, @JennyJun9999
You just need to use "all" function to create two measure, then use divide function to get your expected output.
Of course, it depends on the row context of the current visual.
If you still have the problem, please share some sample data and your expected output.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Lin
hi, @JennyJun9999
You just need to use "all" function to create two measure, then use divide function to get your expected output.
Of course, it depends on the row context of the current visual.
If you still have the problem, please share some sample data and your expected output.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Lin