Forum Discussion

RickPowerBI's avatar
RickPowerBI
Icon for Helper I rankHelper I
6 years ago
Solved

Filter on a measure

Hi all,   I need to Filter on a measure. The measure I have is: active clients. But in those active clients I want to know the count of how many only a Mono contract. Which syntax do I use for thi...
Filter
measure
  • stevedep's avatar
    stevedep
    6 years ago

    Hi,

    Assuming you are sharing your source table, it should be:

     

     

    Measure = CALCULATE(COUNTROWS('Table');FILTER(ALL('Table');'Table'[Dual]==0 && 'Table'[Mono] >0))

     

     

    As can be seen here:

    To be validated using this Power BI file. 

    Please mark as solution if this is what you are looking for. Appreciate the kudo's / thumbs up.

    Kind regards, Steve. 

     

  • RickPowerBI's avatar
    RickPowerBI
    6 years ago

    Greg_Deckler 

    Thank you for the feedback. As I was thrying to explain the question, I found the answer.
    So the problem is fixed!

     

    Kind regards

     

stevedep's avatar
stevedep
Icon for Memorable Member rankMemorable Member
6 years ago

Hi,

Assuming you are sharing your source table, it should be:

 

 

Measure = CALCULATE(COUNTROWS('Table');FILTER(ALL('Table');'Table'[Dual]==0 && 'Table'[Mono] >0))

 

 

As can be seen here:

To be validated using this Power BI file. 

Please mark as solution if this is what you are looking for. Appreciate the kudo's / thumbs up.

Kind regards, Steve. 

 

  • RickPowerBI's avatar
    RickPowerBI
    Icon for Helper I rankHelper I
    6 years ago

    stevedepThank you for the reply. I was looking at the problem the wrong way so i did something completly different, and it works.

    But thanks nonetheless👍