Forum Discussion

RasmusLVF's avatar
RasmusLVF
Frequent Visitor
5 years ago

Migrating from Tableau, Fixed LOD help

Hi We are migrating from Tableau, and trying to move a whole lot of reports from Tableau to PowerBI. Its mostly progressing without issues, unfortunately I got a little stuck trying to replicate a f...
RasmusLVF's avatar
RasmusLVF
Frequent Visitor
5 years ago

Thank you for the reply.

I does appear to be working, but doesnt seem to give me the same functionality as Tableau did.

 

Its a somewhat complicated issue but in short, the txtid field is there to identify if the datasource came from 1 or 2 files. In case it came from 2 files, one of them will always be a duplicate and must be removed. Hence, the tableau lod calculation function was to always only include the "minimum" txtid, and exclude everything else.

 

In tableau, when using the calculation:

[txtID] = { FIXED [EAN],[Dato] : MIN([txtID]) }

The result was a calculated field with 2 options, True or False.

 

.. And I am struggling to figure out how to get the same functionality in PowerBI 🙂

RasmusLVF's avatar
RasmusLVF
Frequent Visitor
5 years ago

I figured it out.

 

First:

[txtID] = { FIXED [EAN],[Dato] : MIN([txtID]) }

 

And then: (To create the filter)

IF(mytable[txtID]=mytable[TxtID_MIN],1,0)