Calculating Percentage of Total Using Quick Measures

[Anonymous]

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 of sales that come from each one.

I see the quick measure options that deal with filters, but these either give me the absolute difference or a percent difference... Can anyone please explain this to me? I want to avoid using DAX as programming is not my specialty.

[v-piga-msft]

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

[Anonymous]

Realized you could accomplish this by creating a quick measure off of another quick measure. Seems ridiculous that a workaround is necessary for such a simple metric, but I guess when you're dealing with Microsoft, common sense isn't all that common...