Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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..
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!