Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 V...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Try like

    CALCULATE([Value],Filter('Table',  CONTAINSSTRING('Table'[Entite],"DR")))

     

    What is expected output, and what are you getting

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Try like

CALCULATE([Value],Filter('Table',  CONTAINSSTRING('Table'[Entite],"DR")))

 

What is expected output, and what are you getting