Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
RasmusLVF
Frequent Visitor

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 3
Anonymous
Not applicable

@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

 

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 🙂

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) 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors