Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a measure (Downtime) that takes many values from many tables and calculates something. The final result is a number.
When I plot this number against a date axis (like on a column chart) some values are blank - this is fine.
I want to find out the number of days that this measure was a blank. There is a date slicer on the page of this visual. Please help! Thanks!
Solved! Go to Solution.
Just tried it - it gives 7 as a result for the above example - should return 2 😞
Hi @Anonymous ,
Would a measure like this work for you?
_blankDays =
CALCULATE(
COUNT(aTable[Date]),
ISBLANK([downtimeMeasure])
)
Pete
Proud to be a Datanaut!
Just tried it - it gives 7 as a result for the above example - should return 2 😞
@Anonymous ,
Are you using a related calendar table for your chart axis? If so, try something like this:
_blankDays =
CALCULATE(
COUNT(Calendar[Date]),
FILTER(
Calendar,
ISBLANK([downtimeMeasure])
|| [downtimeMeasure] = 0
)
)
Pete
Proud to be a Datanaut!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |