DAX calculation for actual %

[eveliva]

Hi,

we are trying to create a calculation in Power BI for a fixed percentage of Nr. of records, which is not influenced by filtering.

We have several Service codes and respective % for every code. But when we choose only one code the % has changed to 100%. We need to see the actual % of specific service codes. (example: when filtering the first code to show 64.64%, not 100% as on the second image).

Could you please advise what DAX calculation we should use in this case to show the actual % even if we use filtering?

Thank you

[Dangar332]

hi, @eveliva 

use ALLSELECTED()  function in side of your measue number of requsts

[eveliva]

Hi, thank you for your suggestion, but it is not working for me since i use filters for Market Area, and when i filter only 2 Market Areas the % is changed and shows the actual % against all numbers not only my 2 Market areas. 

Left viz I with working actual % but not correct share since the explained above. The right viz i with correct share but it is not working actual%.