topic Re: Tableau formula into power bi Dax in DAX Commands and Tips

Tableau formula into power bi Dax

Anonymous — Thu, 03 Feb 2022 05:27:55 GMT

How can I write this formula in Power BI

100 * SUM([Sales])
/
TOTAL(SUM({ fixed [Retailer1], [Product Category1], [Product Sub-Category1], [DateFilter] : SUM([Sales])}))

and

Is there any in detailed blog or video which can explain me how to convert Tableau LOD into DAX

Re: Tableau formula into power bi Dax

amitchandak — Thu, 03 Feb 2022 05:50:27 GMT

Anonymous , Fixed is a little bit tricky . It need to be forced at fact table level, you can not do with diemension

Divide(100 * SUM([Sales])
, calculate(SUM([Sales]), filter(all(Table), [Retailer1] = max([Retailer1]) && [Product Category1] = Max([Product Category1])
&& [Product Sub-Category1] = max([Product Sub-Category1])))
)

Tableau Vs Power BI- Chapter 6- LOD- FIXED (Level of Details): https://youtu.be/QdnOHcZqkPU

Re: Tableau formula into power bi Dax

Anonymous — Thu, 03 Feb 2022 06:18:18 GMT

How do we incorporate date filter in it?

Re: Tableau formula into power bi Dax

amitchandak — Thu, 03 Feb 2022 07:41:40 GMT

Anonymous ,

if you want to add filter one is allselected

Divide(100 * SUM([Sales])
, calculate(SUM([Sales]), filter(allselected(Table), [Retailer1] = max([Retailer1]) && [Product Category1] = Max([Product Category1])
&& [Product Sub-Category1] = max([Product Sub-Category1])))
)

second is

Table[Date] in allselected('Date'[Date]) 0 ))
)