Forum Discussion

Shavo26's avatar
Shavo26
Frequent Visitor
4 years ago

Unselect multiple raws when only 1 in checked

Hi, I have a problem that I need help figuring out the solution. I have a lot of different visuals based on a table, containing an unique ID for each row. Today, I  have a new table, which contain...
Need Help
Shavo26's avatar
Shavo26
Frequent Visitor
4 years ago

Thanks for your solution.
I already tried a lot for the exclusion slicer. The issue thats stay is that the measure is not "linked" to the data and cannot be used in other visuals with the same result, hasException is calculated again depending on the way the data is aggregated.

I think my issue can be formulated as so : how can I link the result of a measure in a visual (itself depending on the slicer result - this part is ok I think) to the data so it stays as an information?
How can hasException be calculated at some point and be linked to the ID for all the visual, so I can filter on it the same way on all the visuals of the report?

Thanks a lot

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    That is indeed a more difficult question than doing it for a particular measure.

     

    I've not tried this, but maybe you could do it by using a calculation group page filter with a calculation item like:

    CALCULATE (
    SELECTEDMEASURE (),
    EXCEPT ( VALUES ( Fact[ID] ), VALUES ( Exclude[ID] ) )
)