Forum Discussion
add filters with calculation
Greetings everyone, I have been fiddling with my Power BI, and I can't seem to get this done right, so I'll resort on asking.
The problem here is, I need to COUNT all the values in "Idiomas", cept for "es, es-ES,es-41,es-419, es-tradnl and (blank space because this one has no value name to it)", and I just can't do it. I need to make the measure to use it in another calculation, so I can't use the "easy visual filter".
Any thoughts on this? Ask for any information you may need.
2 Replies
- KuragueRegular Visitor
Greetings everyone, I have been fiddling with my Power BI, and I can't seem to get this done right, so I'll resort on asking.
The problem here is, I need to COUNT all the values in "Idiomas", cept for "es, es-ES,es-41,es-419, es-tradnl and (blank space because this one has no value name to it)", and I just can't do it. I need to make the measure to use it in another calculation, so I can't use the "easy visual filter".
Any thoughts on this? Ask for any information you may need.
- v-ljerr-msft
Microsoft Employee
Hi Kurague,
If I understand you correctly, the formula below should work in your scenario. :smileyhappy:
measure = CALCULATE ( COUNTA ( 'Table1'[Idiomas] ), FILTER ( 'Table1', 'Table1'[Idiomas] <> "es" && 'Table1'[Idiomas] <> "es-ES" && 'Table1'[Idiomas] <> "es-41" && 'Table1'[Idiomas] <> "es-419" && 'Table1'[Idiomas] <> "es-tradnl" && 'Table1'[Idiomas] <> "" && 'Table1'[Idiomas] <> BLANK () ) )Regards