Forum Discussion
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(base);
ALLEXCEPT(Base;Base[MAL ASIGNADO]);
ALL(Base[MAL ASIGNADO];Base[MAL ASIGNADO]);
Base[MAL ASIGNADO]=1)
That formula is working but I still need to add 4 filters which are in a column of my table... how can I solve this? ...I need to add the filter in this formula to get the right result.
For your example shown in pcture, you could do something like this:
Measure = CALCULATE ( COUNTROWS ( Table ), NOT ( Table[CRANCOT2] IN { 910, 500, 502 } ) )
