Forum Discussion

zahids's avatar
zahids
Regular Visitor
8 years ago
Solved

SUMX CALCULATION TOTAL

Hi All   I am new to DAX, I am using SUMX in Power Bi Desktop and created a measure named MTD Var % Sumx and the the calculation is shown below                                        SUMX(      ...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    The SUMX function should not be required.  Try this measure

     

    =vw_DSF_Final[CY MTD]/vw_DSF_Final[PY MTD]-1

     

    Format this measure as a %

     

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

The SUMX function should not be required.  Try this measure

 

=vw_DSF_Final[CY MTD]/vw_DSF_Final[PY MTD]-1

 

Format this measure as a %

 

Hope this helps.