Forum Discussion
Solved
Unable to write iferror syntax
I Tried to write below simple syntax but somehow i am not getting Table.Profie field for writing this syntax. Here i have attached PBIX file, Please help me here to find where went wrong DIVIDE(T...
HI srini_vasan ,
If you are doing a measure you need to aggregations on your calculation you can do one of two approachs:
Create metrics for Profit, Revenue and the Division
Profit = SUM('Table'[Profit]) Revenue = SUM('Table'[Revenue]) Measure = DIVIDE([Profit], [Revenue])Create a single metric
Measure = DIVIDE(SUM('Table'[Profit]), SUM('Table'[Revenue]))
HI srini_vasan ,
If you are doing a measure you need to aggregations on your calculation you can do one of two approachs:
Create metrics for Profit, Revenue and the Division
Profit = SUM('Table'[Profit])
Revenue = SUM('Table'[Revenue])
Measure = DIVIDE([Profit], [Revenue])Create a single metric
Measure = DIVIDE(SUM('Table'[Profit]), SUM('Table'[Revenue]))