Forum Discussion

HenSza's avatar
HenSza
Frequent Visitor
2 years ago
Solved

Measure simplification - ignoring filters

Hi,  I have a couple measures like this, which exludes some filters. Number of Total Users NO FILTER = CALCULATE(COUNT(CONTENT[SCORE]), ALL( USERS[Supervisor Name Level 02], USERS[Supervis...
  • ray_codex's avatar
    ray_codex
    2 years ago

    Why don't you use the complete USERS table as a parameter and not every column? Or else, look at ALLEXCEPT. 

ray_codex's avatar
ray_codex
Icon for Resolver II rankResolver II
2 years ago

Why don't you use the complete USERS table as a parameter and not every column? Or else, look at ALLEXCEPT. 

HenSza's avatar
HenSza
Frequent Visitor
2 years ago

Because I didn't think about it. Thank you, excellent solution!