Forum Discussion
Anonymous
5 years agoNot applicable
Calculated Measure percent not blank
Hello everyone, I have a table, and I would first like to filter rows where a condition is satified, and then from the rows that remain, calculate the percent of IDs where either of two columns ...
- 5 years ago
You need to upgrade to the March 2021 version of Power BI Desktop. It supports multiple columns now.
If you cannot, use this measure:CALCULATE( COUNTROWS( 'Table' ), FILTER( ALL( 'Table'[MVA?], 'Table'[Insurance 1], 'Table'[Insurance 2] ), 'Table'[MVA?] = TRUE() && ( 'Table'[Insurance 1] ) <> BLANK() || 'Table'[Insurance 2] <> BLANK() ) )But you should be on March 2021 if possible. Only do the above if your IT overlords are evil, or you are on Report Server, which will get this feature in May I think. 😁
Anonymous
5 years agoNot applicable
edhans thank you for your time and help, Ed! It worked 🙏
edhans
Community Champion
5 years agoGreat Anonymous ! Glad I was able to assist, and hopefully show that using FILTER with ALL on a column(s) is fine. It is on a table that it can hit performance issues and is generally not a good practice.