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.
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.
Hi @Kurague,
If I understand you correctly, the formula below should work in your scenario.
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
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.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |