Forum Discussion

mrvamsidhar's avatar
mrvamsidhar
Helper I
8 years ago
Solved

Calculate Total and %

Hello, I am working on Power-Bi Dashboard to set up simple table using below. I need to show % of each product and total sales in a Month. I am having Table1. My output should be Table 2.    Here i...
Need Help
  • mrvamsidhar's avatar
    mrvamsidhar
    8 years ago

    Thanks. I figured it out. CALCULATE(SUM('Table'[Sales]),GROUPBY('Table','Table'[Month]),ALL('Table')).

     

    thats it. - I need to tell to DAX exclude all filters. so ALL() did the trick.

masitbaha's avatar
masitbaha
Regular Visitor
8 years ago

How about using 'Matrix' instead of 'Table'?

  • mrvamsidhar's avatar
    mrvamsidhar
    Helper I
    8 years ago

    Thanks. I figured it out. CALCULATE(SUM('Table'[Sales]),GROUPBY('Table','Table'[Month]),ALL('Table')).

     

    thats it. - I need to tell to DAX exclude all filters. so ALL() did the trick.