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 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!

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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

     

    • 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)