Forum Discussion

cnxanalytics1's avatar
cnxanalytics1
Frequent Visitor
5 years ago

Not getting the correct value after multiplication

Added the Measure:
MaxMinHMR = MAX('Merged CSR sheets'[HMR]) - MIN('Merged CSR sheets'[HMR])

Added Column PrHrBdgt:
each if [Hrs reading]="0-500" and [CostType]="Filter cost" then 10000/500 else if ....
then multiplied:
[MaxMinHMR] * SUM('Merged CSR sheets'[PrHrBdgt])

but the out is not correct the 3rd value 241*20=43380 which should be 4820

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    cnxanalytics1 , if you want to multiple a measure, you need a group level one or more, unsummarized columns in visual

     

    example two group by of visual assumed and added

     

    sumx(summarize(Table, Table[cost ID], Table[Cost type], "_1",[MaxMinHMR] * SUM('Merged CSR sheets'[PrHrBdgt])),[_1])