Filter on a measure

[RickPowerBI]

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 this?

Contract State	Dual	Mono
Active	0	1
Ended	4	0
Ended	2	0
Active	0	3
Active	3	0
Ended	2	0
Active	0	2

Thanks in advance!

[stevedep · Accepted solution]

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. 

[stevedep · Accepted solution]

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]

@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👍

[Greg_Deckler]

@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 · Accepted solution]

@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