Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
@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)
User | Count |
---|---|
47 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |