Forum Discussion

dcrow5378's avatar
dcrow5378
Resolver 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
Resolver 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
Community 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?