Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@Anonymous - Try:
PI Count = COUNTROWS(FILTER('Planning',[PI] <> BLANK()))
@Anonymous - Try:
PI Count = COUNTROWS(FILTER('Planning',[PI] <> BLANK()))
@Anonymous -
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |