Forum Discussion
Formula Conversion
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
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
5 Replies
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/
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
