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..
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.