The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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..