Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Thank you for the feedback. As I was thrying to explain the question, I found the answer.
So the problem is fixed!
Kind regards
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.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
@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👍
@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.
Thank you for the feedback. As I was thrying to explain the question, I found the answer.
So the problem is fixed!
Kind regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |