Division of a Filtered Field

[JennyJun9999]

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.  

[v-lili6-msft · Accepted 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