I could use some guidance on how to get a measure to show the percentage difference between text values in a column "SUBREGION". I have created a measure to count each text value that equals "M COUNTY" which is a resident but now I need to get the percent difference between that vs all other subregions who are non residents. I appreciate any help on this!
CountResident = CALCULATE(COUNT(TABLE[Subregion]),'TABLE'[Subregion] = "M County")
RESIDENT (M COUNTY) vs NON RESIDENT (ALL OTHER SUBREGIONS that are not M COUNTY)
Solved! Go to Solution.
Thank you for the prompt response and help! I did use your formula but I don't think it showing the correct percent? Shouldn't it be like 89%? Also do you know how to show the card as a percent?
Thank you! I need percent of M County residents vs non residents (all other). So I need to see percentage of M County (residents) who registered against the non-residents.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps