Forum Discussion
Filter column with containsstring
Hello,
I create a measure to calculate value of only Entite containing "DR": CALCULATE([Value],CONTAINSSTRING('Table'[Entite],"DR"))
Value is measure.
My table is like that :
| Region | Entite | Value |
| National | National | 4 |
| Est | DR 1 | 1 |
| Est | DR 2 | 2 |
| Ouest | AR 1 | 3 |
| Ouest | DR 3 | 1 |
How can i modify the Dax measure to find all Entite of each Region? When i show value in a matrix with only the column 'Entite' and 'Value' , the filter work but when i add the column ' Region' isn't working anymore !
I want to include the Region in the filter.
Thank you for your help
Anonymous , Try like
CALCULATE([Value],Filter('Table', CONTAINSSTRING('Table'[Entite],"DR")))
What is expected output, and what are you getting
2 Replies
Anonymous Try like below:
CALCULATE(Your Measure,Table[Region])
Anonymous , Try like
CALCULATE([Value],Filter('Table', CONTAINSSTRING('Table'[Entite],"DR")))
What is expected output, and what are you getting
