Forum Discussion
ahuhn
Advocate I
Advocate Iuse parameters in dax
I made a DAX measure: Measure = CALCULATE(COUNT(Sheet1[Status]),FILTER(Sheet1,[MonthUpdated]="201810" && [Status]="Alpha")) I also created a parameter YYYYMM to represent [MonthUpdated], to p...
Hi ahuhn
You can get the other count which is not selected by slicer with below measure.
Measure =
CALCULATE (
MAX ( Sheet1[MonthUpdated] ),
FILTER (
Sheet1,
Sheet1[MonthUpdated] <> SELECTEDVALUE ( Slicer[YYYYMM] )
&& Sheet1[Status] = "Alpha"
)
)
Regards,
Cherie
ahuhnAdvocate I
Advocate II forgot to add screenshot:
- parry2k
Super User
ahuhn it is not clear what you are trying to do? Are you setting value for parameters? Why you are setting it as a slicer? Could you provide more details.
Please look at this link on how to get your answer quickly
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
