Forum Discussion
Count blanks in two different measures
Hi All, I've searched and don't think this has been answered before. I have 2 new measures that use 'countblank' to identify how many blanks there are in each. I'm now trying to create one that...
Anonymous , You can create a column with below code and then take a sum of new column:-
Column = IF ( ISBLANK ( COALESCE ( 'Table'[Pred], 'Table'[Succ] ) ), 1, 0 )Output:-
parry2k
Super User
Super UserAnonymous it will be easier if you post sample data with the expected output. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Thanks for replying - here is an example:
I have 'countblank' for predecessors (there are 5) and 'countblank' for successors (there are 7), what I'm trying to get is - how many have blank in both the predecessors and successors columns (there are 3). Does that help?
Martin
Samarth_18Community Champion
Anonymous , You can create a column with below code and then take a sum of new column:-
Column = IF ( ISBLANK ( COALESCE ( 'Table'[Pred], 'Table'[Succ] ) ), 1, 0 )Output:-