Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 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.

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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...

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    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