Forum Discussion
Measure for distinct count based on value from another column
I have the following dataset and I am trying to get the unique value from Name column where the value in Status column is 3 and value not 0 or 2. So the result should be only D.
Any help is greatly appreciated.
| Name | Status |
| A | 0 |
| B | 2 |
| C | 3 |
| D | 3 |
| A | 2 |
| C | 2 |
| B | 0 |
| A | 3 |
2 Replies
- mahoneypat
Microsoft Employee
This measure expression will return a single Name that meets your conditions. Since you are expecting a single value, I assume you will use a card visual.
Name Just Status 3 =
VAR summary =
SUMMARIZE (
'Status',
'Status'[Name],
"@min", MIN ( 'Status'[Status] )
)
RETURN
MINX (
FILTER (
summary,
[@min] = 3
),
'Status'[Name]
)Regards,
Pat
- MattAllington
Community Champion
In DAX, you First filter, then calculate. Inside the calculate function, the first parameter is executed last. So.
=CALCULATE(distinctcount(tablename[name]),tablename[status]=3)the filter is applied first (last parameter), then the calculation is executed
