Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Multiple SELECTEDVALUES conflicting for dynamic MoM Change

It's probably easiest to explain this by starting with an image first What I'm tryin to do is have each one of these lead counts filter to the selected value of the month above them, which are...
Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    6 years ago

    Hi Anonymous ,

     

    SELECTEDVALUES doesn’t support multiple values. So you can use VAUES function.

    The lead count measure as following,

     

    New lead count = 
var monthtouse = VALUES(AlternateDateDim1[MonthAbbrvAndYearName])
var maxdate = calculate(max(AlternateDateDim1[DateSK]),AlternateDateDim1[MonthAbbrvAndYearName] in monthtouse)
var mindate = calculate(min(AlternateDateDim1[DateSK]),AlternateDateDim1[MonthAbbrvAndYearName] in monthtouse)
var leadcount = calculate(DISTINCTCOUNT(Data[Identifier]),Data[CreateDtID] >= mindate,Data[CreateDtID] <= maxdate,USERELATIONSHIP(AlternateDateDim1[DateSK],Data[CreateDtID]))
return leadcount

     

     

     

    The reason why MoM displays blank is the interactions. Please check the interactions between slicers and card visuals.

    The following is the result of our change interaction, is it what you want?

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    BTW, pbix as attached.

v-zhenbw-msft's avatar
v-zhenbw-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

SELECTEDVALUES doesn’t support multiple values. So you can use VAUES function.

The lead count measure as following,

 

New lead count = 
var monthtouse = VALUES(AlternateDateDim1[MonthAbbrvAndYearName])
var maxdate = calculate(max(AlternateDateDim1[DateSK]),AlternateDateDim1[MonthAbbrvAndYearName] in monthtouse)
var mindate = calculate(min(AlternateDateDim1[DateSK]),AlternateDateDim1[MonthAbbrvAndYearName] in monthtouse)
var leadcount = calculate(DISTINCTCOUNT(Data[Identifier]),Data[CreateDtID] >= mindate,Data[CreateDtID] <= maxdate,USERELATIONSHIP(AlternateDateDim1[DateSK],Data[CreateDtID]))
return leadcount

 

 

 

The reason why MoM displays blank is the interactions. Please check the interactions between slicers and card visuals.

The following is the result of our change interaction, is it what you want?

 

 

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

BTW, pbix as attached.