Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello, I am trying to use a field from a dimensional table as a filter in the report. When I use this field as column in the table, the values populate as expected. The error happens when I try to filter to 0. The table returns rows that have no value in the dataset (technically NULLS because there is no actual value in the associated table for these rows). I have discussed this with my team at work and we feel that PBI may have a bug when it comes to this. One solution for a workaround is to use Advanced Filter and select 'is 0' and 'is not blank', but this option is not ideal for our use case. Can someone please help? Screenshot below. Thanks!
Solved! Go to Solution.
Since BLANK() = 0 returns TRUE, it can cause unexpected behavior. One approach is to create a custom column "Amount Filter" in Power Query for filtering:
if [Amount] = null then "Blank" else [Amount]
Results:
Additional reading:
https://dax.guide/op/strictly-equal-to/
Proud to be a Super User!
Thanks for responding. The strictly equal to article was helpful and I was able to get a calculated column to work by incorporating IF [column] == BLANK() then 999 else [column]. This then assigns the previous blanks to 999 which can be filtered out. Thanks!
Since BLANK() = 0 returns TRUE, it can cause unexpected behavior. One approach is to create a custom column "Amount Filter" in Power Query for filtering:
if [Amount] = null then "Blank" else [Amount]
Results:
Additional reading:
https://dax.guide/op/strictly-equal-to/
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |