Forum Discussion

dcrow5378's avatar
dcrow5378
Icon for Resolver I rankResolver I
4 years ago
Solved

Sum Switch Values

I have a measure that looks at the Value of the current month and compares it to the previous month and applies a switch function if higher than the previous month.  I would like to be able to sum th...
  • smpa01's avatar
    smpa01
    4 years ago

    dcrow5378  can you try this

    Measure 2 = SUMX(addcolumns(summarize(qm,QM[FacilityID],QM[Indicator],QM[Report Month]),"mx",[Measure]),[mx])

     

     

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

dcrow5378  does this give you what you need

Measure =
SUMX (
    'QM',
    VAR PriorMonthAmt =
        CALCULATE ( [Max FAP], PARALLELPERIOD ( 'QM'[Report Month], -1, MONTH ) )
    VAR Compare =
        IF ( ISBLANK ( PriorMonthAmt ), BLANK (), PriorMonthAmt - [Max FAP] )
    RETURN
        SWITCH ( TRUE (), Compare = 0, 0, Compare < 0, 1, Compare > 0, 0 )
)

 

I am gueesing QM is the table where you have the column Indicator

dcrow5378's avatar
dcrow5378
Icon for Resolver I rankResolver I
4 years ago

smpa01  Yes, QM is the table where I have the column indicator.
I did try something like this, and I just tried yours, and for some reason this is giving me all zeros, even though the values have increased from previous months?