Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
So I have a BI Measure that shows the percentage.
This is the measure:
Cost blank =
VAR __AmountBlank = CALCULATE(COUNT(X[Cost]), X[COST] = BLANK())
VAR __Total = COUNT(X[Cost])
RETURN
DIVIDE(__AmountBlank, __Total, -1)
The variable __AmountBlank returns the value 382 965.
When I go to the data view, and filter Cost on blank it returns 2 753 records.
I also tried ISBLANK(X[COST]) and X[COST] = "" (this returns an error) but nothing works..
How do I resolve this issue?
Solved! Go to Solution.
Hi @Anonymous
Please the below formula for count of blank rows. Take measure
Hi @Anonymous
Please the below formula for count of blank rows. Take measure
This worked! Thanks a lot!
HEllo @Anonymous ,
try
VAR __AmountBlank = CALCULATE(COUNTROWS('TableName'), X[COST] = BLANK())
Proud to be a Super User! | |
Interesting, did not try this yet! Unfortunately it does give the same result as the previous one..
User | Count |
---|---|
98 | |
75 | |
74 | |
49 | |
26 |