Forum Discussion

Atif's avatar
Atif
Icon for Resolver I rankResolver I
5 years ago
Solved

Issue with SUMX

DIVIDE( SUM(Table1[Purchase Value]), SUMX(ALL(Table1), Table1[Purchase Value]))   The above formula works fine without any filters. Since I am using ALL function, the filtered numerator still gets...
Need Help
Show and Tell
  • Atif's avatar
    Atif
    5 years ago

    Thank you, sanalytics !

     

    A minor tweaking and it worked.
     
    DIVIDE( SUM(Table1[Purchase Value]), CALCULATE(SUM(Table1[Purchase Value]), ALL(Table1[Brand])))
sanalytics's avatar
sanalytics
Icon for Super User rankSuper User
5 years ago

Atif ..
Please upload your power bi model and dummy data so that we can have a look..
Regards,

sanalytics

 

Atif's avatar
Atif
Icon for Resolver I rankResolver I
5 years ago

Thank you, sanalytics !

 

A minor tweaking and it worked.
 
DIVIDE( SUM(Table1[Purchase Value]), CALCULATE(SUM(Table1[Purchase Value]), ALL(Table1[Brand])))