Forum Discussion
Calculating Percentage of Total Using Quick Measures
Hi All, I'm looking to do something very simple, that for whatever reason, does not seem to be supported in quick measures. Basically I have two categories and I'm trying to calculate the percent...
Hi Anonymous,
It seems that you want to calculate the percentage of total. Here is one way which may help you achieve that.
Assuming that you have table like this:
Then you could select show values as Percent of Grand total.
Please note that this quick option will show you the percent of grand total base on your filter.
In addition, quick measure is convenient but it has some limitation. It only provides some comman measures. If you want to do more calculations in Power BI, you'd better have a good learning of DAX.
If you still need help for your scenario, please share your data sample and your desired output so that I can test and share a dax measure for you.
Best Regards,
Cherry