Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello all,
I have observed a behaviour in DAX that I can't understand.
I want to compare the "Leadtime" column in a table to determine the elements with "Leadtime" greater than a threshold:
Solved! Go to Solution.
Hi @Anonymous
You have a calculated column in your table . That is static and there is no filter context; that's why your measure will always yield 180 HASONEVALUE is always FALSE. You need to create a measure and use it in the table visual:
00_IsLTmorethanT2_Measure = (SELECTEDVALUE('AO Input'[Ges. Beschaffungszeit]) > 'AO Input'[10_minLT2])and get rid of the 00_IsLTmorethanT2 column. See attached file
Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.
Cheers
Hi @Anonymous
You have a calculated column in your table . That is static and there is no filter context; that's why your measure will always yield 180 HASONEVALUE is always FALSE. You need to create a measure and use it in the table visual:
00_IsLTmorethanT2_Measure = (SELECTEDVALUE('AO Input'[Ges. Beschaffungszeit]) > 'AO Input'[10_minLT2])and get rid of the 00_IsLTmorethanT2 column. See attached file
Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.
Cheers
Great thanks @AlB , it works great and I accepted your reply as solution.
Actually, in my full report I still have the issue that the comparison result is not updated. That report is much more complicated, with different tables & relations among them.
I'll try sorting it out myself, keeping in mind that calculated columns are static.
Thanks again and have a nice day!
Hi @Anonymous
Can you share the pbix, or a simplified version thereof that reproduces the issue?
@AlB Thanks for replying.
yes, sure I can share a reduced version.
What is the recommended way of sharing pbix? I checked out the "using the community" forum but did not find instructions there.
(maybe a hint for @BrandyG_iTalent to add a "how to share a pbix with the community" there).
Many thanks and regards.
@Anonymous
Sounds like a good idea. Many people actually ask that.
You have to share the URL to the file hosted elsewhere: Dropbox, Onedrive... or just upload the file to a site like tinyupload.com (no sign-up required).
Hello @AlB ,
I'll do with onedrive:
In the folder I added the pbix and the data source (an excel sheet).
Thanks again,
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |