Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
HI People,
How can I convert This Tableau Formula to Power BI?
{FIXED [ID:MAX(IF [Item]="A THEN [Item]END)}
This would find if Item="A" for ID 1, then It would write A across all Rows for 1.
ID | Item | Result |
1 | A | A |
1 | B | A |
1 | C | A |
Thanks
Deepak
Solved! Go to Solution.
Hi Daniel,
Your logic will definitely work in the case "A" is minimum, which is actually Minimum in the example but actually my Data set is something like this
Suppose the dataset Looks like This:
ID | Item |
1 | Soap |
1 | Pen |
1 | Pencil |
2 | Soap |
2 | Rubber |
2 | Paper |
In Tableau, I would Simply write this
{FIXED ID:MAX(IF Item="Soap" Then Item end)}
to get This:
ID | Item | Result |
1 | Soap | Soap |
1 | Pen | Soap |
1 | Pencil | Soap |
2 | Soap | Soap |
2 | Rubber | Soap |
2 | Paper | Soap |
I am looking for Similar Logic in Power BI.
Thanks a lot
Deepak
Hi @drrai66,
Based on my test, you could try this formula:
Measure = CALCULATE(MAX(Table1[Item]),FILTER(ALL('Table1'),'Table1'[Item]="M"))
Result:
Regards,
Daniel He
Hi @drrai66,
Based on my test, you could refer to below formula:
Measure = CALCULATE(MIN('Table1'[Item]),FILTER(ALLSELECTED('Table1'),'Table1'[ID]=1))
Result:
Regards,
Daniel He
Hi Daniel,
Your logic will definitely work in the case "A" is minimum, which is actually Minimum in the example but actually my Data set is something like this
Suppose the dataset Looks like This:
ID | Item |
1 | Soap |
1 | Pen |
1 | Pencil |
2 | Soap |
2 | Rubber |
2 | Paper |
In Tableau, I would Simply write this
{FIXED ID:MAX(IF Item="Soap" Then Item end)}
to get This:
ID | Item | Result |
1 | Soap | Soap |
1 | Pen | Soap |
1 | Pencil | Soap |
2 | Soap | Soap |
2 | Rubber | Soap |
2 | Paper | Soap |
I am looking for Similar Logic in Power BI.
Thanks a lot
Deepak
Hi @drrai66,
Based on my test, you could try this formula:
Measure = CALCULATE(MAX(Table1[Item]),FILTER(ALL('Table1'),'Table1'[Item]="M"))
Result:
Regards,
Daniel He
Yes That's It!!! Thanks a Lot
This would be something along the lines of a measure with the formula:
=CALCULATE(MAX(Table[Item]), ALLEXCEPT(Table, Table[ID]))
FIXED LODs roughly translate to ALLEXCEPT:
https://dataveld.com/2018/02/17/tableau-to-power-bi-fixed-lod-expressions/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |