Forum Discussion

Sidhu's avatar
Sidhu
Frequent Visitor
4 years ago

Converting Tableau Fixed to Power BI

I am trying to convert the tableau report to PowerBI and having hard time converting these calcualted fields

 

Measure 1 = sum(zn([Value1]))*sum(zn([Value2]))/sum(zn([Value3]))
Measure 2 = { FIXED [Table1D1],[Table1D2],[Table1D3],[Table2D1],[Table3D1],[Table4D1]:[Measuere1]}
Measure 3 = sum([Measure2]*[Value4])/sum([Value4])

 

Is there a easy way to do this in PBI using calculated columns or measures?

2 Replies

    • Sidhu's avatar
      Sidhu
      Frequent Visitor

      I am looking for some help in converting them, I did the basic conversion, the measures are showing right values at the row level but the totals are not showing accurately.