Forum Discussion
What is wrong with this DAX?
Hi All, I need to calculate what is the total no. of rows where PI is NOT Blank from the Planning table. So I wrote the DAX PI Count = IF(ISBLANK(MAX(Planning[PI])),Blank(),COUNT(Pl])). But i...
Anonymous - Try:
PI Count = COUNTROWS(FILTER('Planning',[PI] <> BLANK()))
Greg_Deckler
Community Champion
Community ChampionAnonymous -
PI Count = IF(ISBLANK(MAX(Planning[PI])),Blank(),COUNT(Pl])).
So basically what this says is get the MAX of the column PI and check if it is BLANK. But, this is going across the entire table in context, not row by row (iterator) so it will likely never be blank because you are getting the MAX. Thus, you always get the count of the rows in the table in context. I would suspect that if you used MIN you would end up always getting BLANK since the mininum value in that column is probably BLANK.
Greg_Deckler Thanks you so much Greg 👍