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])

     

     

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?

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

dcrow5378  sorry 'bout that. Is it kindly possible to reproduce a pbix in a small scale with identical measures for me/anyoneelse to debug?