Forum Discussion

nmhung49's avatar
nmhung49
Icon for Helper II rankHelper II
5 years ago
Solved

% Propotion In Maxtrix

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

Need Help
  • DataInsights's avatar
    DataInsights
    5 years ago

    nmhung49,

     

    Your measure was right except for the ALLSELECTED argument: it needs Data[Product] instead of the entire Data table.

     

    %Propotion = 
DIVIDE ( [Total sale], CALCULATE ( [Total sale], ALLSELECTED ( Data[Product] ) ) )

     

     

1 Reply

  • DataInsights's avatar
    DataInsights
    Icon for Super User rankSuper User
    5 years ago

    nmhung49,

     

    Your measure was right except for the ALLSELECTED argument: it needs Data[Product] instead of the entire Data table.

     

    %Propotion = 
DIVIDE ( [Total sale], CALCULATE ( [Total sale], ALLSELECTED ( Data[Product] ) ) )