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 ,

Thanks for the update!
To help investigate further, could you please share some sample data or a minimal reproducible example that demonstrates the issue? That would really help in identifying a suitable solution.
How to provide a sample data
How to upload in Community

Best Regards,
Shruti