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

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

RickPowerBI - I'm not clear on what I am looking at. Is that source data, expected output or ? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

RickPowerBI's avatar
RickPowerBI
Icon for Helper I rankHelper I
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