Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

filter in DAX

  Hi Community I need some help....Im trying to build a DAX but I need to filter certain words which are in other column.   Any suggestion to improve my DAX:    MAL ASIGN = CALCULATE(COUNTROWS(b...
Need Help
  • AkhilAshok's avatar
    AkhilAshok
    7 years ago

    For your example shown in pcture, you could do something like this:

    Measure =
CALCULATE ( COUNTROWS ( Table ), NOT ( Table[CRANCOT2] IN { 910, 500, 502 } ) )
AkhilAshok's avatar
AkhilAshok
Solution Sage
7 years ago

For your example shown in pcture, you could do something like this:

Measure =
CALCULATE ( COUNTROWS ( Table ), NOT ( Table[CRANCOT2] IN { 910, 500, 502 } ) )
Anonymous's avatar
Anonymous
Not applicable
7 years ago

THANK YOU AkhilAshok@!!!!!! SO CLAIR...IN THIS CASE THE FORMULA WORKED perfect and it looks like this

 

MAL ASIGN = CALCULATE(COUNTROWS(base);
NOT Base[CCVISITA] IN {"910"; "500";"502";"501"}  ;
ALLEXCEPT(Base;Base[MAL ASIGNADO]);ALL(Base[MAL ASIGNADO];
Base[MAL ASIGNADO]);Base[MAL ASIGNADO]=1;'Grupo R'[RECURSO (groups)]="RE")

 

Really thank you!!!!!!!