Forum Discussion
Oscar_Mtz_V
Kudo Commander
4 years agoDistinct count of only the minimum value
This is my data table: Support.pbix I need to have a disctinc count of employees IDs but only count when the instance where they appear is less than or equal to three, and only count the minor ...
- 4 years ago
amitchandak , your response although not the solution, guided me through the right path.
The key here was the VAR selValue which applied the correct context when used in a Matrix and replaced the SUM for a MIN.Also, I didn't hard code the value "3", in its place I used a parameter.
Here is the final DAX that did the trick:
DCount GUID min with parameter = VAR selValue = SELECTEDVALUE('Append'[Standard Value]) VAR Calc= COUNTX( FILTER( SUMMARIZE( ALLSELECTED('Append'), 'Append'[Employee GUID], 'Append'[UniqueID], "Min", MIN('Append'[Standard Value]) ), [Min] <= [Parameter Value] && [Min] = selValue ), [Employee GUID] ) RETURN Calc
Oscar_Mtz_V
Kudo Commander
4 years agoamitchandak , your response although not the solution, guided me through the right path.
The key here was the VAR selValue which applied the correct context when used in a Matrix and replaced the SUM for a MIN.
Also, I didn't hard code the value "3", in its place I used a parameter.
Here is the final DAX that did the trick:
DCount GUID min with parameter =
VAR selValue = SELECTEDVALUE('Append'[Standard Value])
VAR Calc=
COUNTX(
FILTER(
SUMMARIZE(
ALLSELECTED('Append'),
'Append'[Employee GUID],
'Append'[UniqueID],
"Min", MIN('Append'[Standard Value])
),
[Min] <= [Parameter Value] &&
[Min] = selValue
),
[Employee GUID]
)
RETURN
Calc
amitchandak
Super User
4 years agoKudos to you !!