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