Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Have some calc in tableau , need similar function to get desired result using power BI DAX
{ FIXED [Customer Number],[Segment]:MAX(IF [Region] in ('East') then ([Sales]) END)}
Solved! Go to Solution.
Hi @kishore23348 ,
It may look like this in Power BI DAX by creating a measure:
A =
CALCULATE (
MAX ( 'table'[Sales] ),
ALLEXCEPT ( 'table', 'table'[Segment], 'table'[Customer Number] ),
'table'[Region] = 'East'
)
Refer:
Tableau LODs converted into Power BI Dax – Part 1
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @kishore23348 ,
It may look like this in Power BI DAX by creating a measure:
A =
CALCULATE (
MAX ( 'table'[Sales] ),
ALLEXCEPT ( 'table', 'table'[Segment], 'table'[Customer Number] ),
'table'[Region] = 'East'
)
Refer:
Tableau LODs converted into Power BI Dax – Part 1
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
It would help us if you could explain what the formula does in Tableau.
I think that the FIXED at the beginning is to keep the filter on Cust numb and Segment ?
If it is the case an "equivalent" in DAX would be KEEPFILTERS(Cust Number, Segment).
It seems as weel that you have a FILTER(Region="East"), but I don't know Tableau enough to tell you more.
You have that thread as weel thta might help you :
https://community.powerbi.com/t5/Desktop/From-Tableau-to-PowerBI-DAX/m-p/388778
Hope it gets you on the track