topic Re: Migrating from Tableau, Fixed LOD help in DAX Commands and Tips

Migrating from Tableau, Fixed LOD help

RasmusLVF — Tue, 27 Oct 2020 09:28:41 GMT

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 fixed lod expression which was designed to remove duplicate values in tableau - meaning if 2 lines existed the code would identify the "earliest" value and disregard the duplicate values.

The Tableau expression: (Which resulted in a True/False filter)

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

I've tried a few different approaches in PowerBI but without success.

Can someone help me out?

Thanks in advance!

Re: Migrating from Tableau, Fixed LOD help

Anonymous — Tue, 27 Oct 2020 11:27:32 GMT

RasmusLVF
Hey Mate ,
You can use this .

Test =
CALCULATE (
    MIN ( 'you table'[txtID] ),
    ALLEXCEPT (
         'you table' ,
        'you table'[EAN],
        'you table'[Dato]
    )
)

'Your Table '-Name it with your Table name then followed by your column name Like 'you table'[txtID] 

try this and let me know if it work for you .

Thank you Mate Cheers

Re: Migrating from Tableau, Fixed LOD help

RasmusLVF — Tue, 27 Oct 2020 12:40:28 GMT

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 🙂

Re: Migrating from Tableau, Fixed LOD help

RasmusLVF — Thu, 29 Oct 2020 12:25:14 GMT

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)