Forum Discussion

kiran123's avatar
kiran123
Frequent Visitor
6 years ago

Devide

Hi Team,

I am stuck with some calculation part in my reports that is the calcuation of measure and column

i have a one measure and another is column so need to devide a measure and the column how can it be possible and both are in same table if i can calculate like this 

Result = DIVIDE([Measure], CALCULATE(SUM(Table[Column])),0)

it will also give an error of circular dependancy Please let me know if anyone have the solution to this.

Thanks in Advance

 

 

 

Need Help

1 Reply

Replies have been turned off for this discussion
  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    HIi kiran123 ,

    Could you show me the DAX formula of the measure and the calculated column?

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.