Hi everyone,I have a table and I would like to get % Propotion for by Months
I'm having difficulty in writing formulas DAX for this case
Now my dax only correct for Grand Total
For example, as shown below
Please see the acttached file
Go to Solution.
Your measure was right except for the ALLSELECTED argument: it needs Data[Product] instead of the entire Data table.
DIVIDE ( [Total sale], CALCULATE ( [Total sale], ALLSELECTED ( Data[Product] ) ) )
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.