Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Running into an issue with a measure we can't figure out. Here are the details:
X is a pre-existing measure we created that sums all the amounts in a column that fall on the same date. We are happy with this measure.
This is where we need some help:
Measure = IF( X <> 0), then show all rows that only have values that are not 0 (no blanks or nulls).
What is the DAX for this? We have tried many different DAX functions but they all seem to be include 0's.
Hi @amceachern,
Please share a sample and the formula of [X]. The [X] could alter the context.
Best Regards,
Dale
Can you provide a sample dataset where your measure didn't work correctly?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |