Forum Discussion

quijote's avatar
quijote
Frequent Visitor
1 year ago
Solved

Comparing DAX Measure with SELECTEDVALUE()

Sorry, I am still quite new to PowerBI and DAX.   I have created two measures:    1. Localism = SELECTEDVALUE('ISSUE'[RaisedBy], "None")   which returns the user-selected slicer value for [Rai...
Need Help
  • quijote's avatar
    quijote
    1 year ago

    Thanks for looking into this.

     

    I think I just fixed it with the following tweak:

     

    Other_Template = CALCULATE(COUNTROWS(ISSUE), ISSUE[RaisedBy] <> SELECTEDVALUE('ISSUE'[RaisedBy], "None"), ISSUE[CountriesImpacted] = "Template")
     
    Although your solutions looks more elegant, to be sure...
v-sdhruv's avatar
v-sdhruv
Community Support
1 year ago

Hi quijote ,

Good that you were able to resolve your query.
Can you please mark the answer as solution, so that other users can also benefit from it.
Thanks AlexisOlson  and speedramps  for your detailed response to the query.
Please feel free to reach out in case of any questions.
Thank You

  • quijote's avatar
    quijote
    Frequent Visitor
    1 year ago

    Actually, this is not resolved yet.

     

    I have the same problem but am investigating a suitable solution.

     

    Will post here if / when I find one.