Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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,
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
8 |