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
Check out the News & Announcements to learn more.
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!