Forum Discussion
Helper IFilter 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 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!
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.
Thank you for the feedback. As I was thrying to explain the question, I found the answer.
So the problem is fixed!Kind regards
4 Replies
- Greg_Deckler
Community Champion
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.
RickPowerBIThank you for the feedback. As I was thrying to explain the question, I found the answer.
So the problem is fixed!Kind regards
- stevedep
Memorable Member
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👍
