Forum Discussion
Incorrect Measure Totals
Hello - I have the below measures in which the result is showing correctly but the total is incorrect. Can you help how I can resolve this issue?
1) Sale = CALCULATE(IF([Gross Amount]<7000,0,IF([Gross Amount]>100001,5000,([Gross Amount]*.05))))
Gross Amount above is also measure. Gross Amount = calculate(sum(Invoice[SellAmount]) - sum(Invoice[Amount]) + sum(Invoice[IntrestAmount])
gauravnarchal , You need force a row context from visual to get this corrected
Sale = Sumx(Values(Table[ID]) , CALCULATE(IF([Gross Amount]<7000,0,IF([Gross Amount]>100001,5000,([Gross Amount]*.05)))) )
refer why grand total
1 Reply
gauravnarchal , You need force a row context from visual to get this corrected
Sale = Sumx(Values(Table[ID]) , CALCULATE(IF([Gross Amount]<7000,0,IF([Gross Amount]>100001,5000,([Gross Amount]*.05)))) )
refer why grand total