Forum Discussion
Sidhu
4 years agoFrequent Visitor
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
- RayWu
Memorable Member
Sidhu yes you can via quick measure by right clicking on the data .
In power bi we used dax, if you not familar with it , worth checking out https://dax.guide/functions/logical/- SidhuFrequent 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.