Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Validate Slicer Selection

Hello   I have a period column in a table that I am using as a slicer. It is of type date and I am using it as a Date Hierarchy.  I need to validate if the user selected the same number of months ...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    Anonymous here you go, add following measure

    Month Selected = 
VAR __year = 
SUMMARIZE ( 
    'Calendar', [Year], "@Months", CONCATENATEX ( VALUES ( 'Calendar'[Month] ), [Month], "," ) 
)
VAR __status =
IF ( COUNTROWS ( VALUES ( 'Calendar'[Year] ) ) = 1, -1,
    COUNTX ( 
        SUMMARIZE ( __year, [@Months], "@Rowcount", COUNTROWS ( __year ) ), [@Rowcount] 
    ) 
)
RETURN
SWITCH ( 
    __status,
    1, "Valid Selection", 
    -1, "Invalid Selecton - Only months selected in one year",
    "Invalid Selection - not same months selected"
)

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

parry2k's avatar
parry2k
Super User
5 years ago

Anonymous here is a small video that shows the working of it

 

 

 

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I've tried your code and it seems to work for my scenario. Thank you for your support and also thank you to everyone that gave suggestions.