Forum Discussion
SelflearningBi
Helper III
Helper IIICount the blank cell
Estimate Performance =
IF(ISFILTERED('On Time?'[On Time ?]),
VAR Result = CALCULATE(COUNT('IIC Sample'[Model Name]),FILTER('IIC Sample', 'IIC Sample'[Estimate ETA vs Requst ETA IIC]>= SELECTEDVALUE('On Time?'[Left]) && 'IIC Sample'[Estimate ETA vs Requst ETA IIC]<= SELECTEDVALUE('On Time?'[Right])))
Return IF(ISBLANK(RESULT),0, Result),
COUNT('IIC Sample'[Model Name]))
Im using above dax measue, everything looks correct, except the blank cell is not showing up.
How to still count the blank cell. there are actually 58 is blank; without having any input yet. I would also want to know how many of them.. How should I write that in dax measure
I have this caclauted column, i think now it put the blank as ON TIME...
Im using above dax measue, everything looks correct, except the blank cell is not showing up.
How to still count the blank cell. there are actually 58 is blank; without having any input yet. I would also want to know how many of them.. How should I write that in dax measure
I have this caclauted column, i think now it put the blank as ON TIME...
Hi SelflearningBi ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want. Please add one row as below in the table 'On Time?':
Best Regards
1 Reply
Hi SelflearningBi ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want. Please add one row as below in the table 'On Time?':
Best Regards