Forum Discussion

talespin's avatar
talespin
Icon for Solution Sage rankSolution Sage
2 years ago

This I understand

"What I'm trying to do is, I want to put a few measure on a table and when I make a selection from a field, I want only some calculations get affected from that selection, and some others don't."

 

I am sorry i could not fully understand the details, can you please simplify your requirement. I saw the file, there are many table visuals and measures. Can you please keep one measure for starter and explain what should impact this measure and what should not

(explicitly mentioning whether you are referring to a slicer or attribute in visual. "when I make a selection from a field" - Please explain. )

 

boraJustmop's avatar
boraJustmop
Frequent Visitor
2 years ago

Basicly , when I make a selection from avaiability field  table that based on service category, should not be affected. 

AS you see on the SS, availability field selected and TABLE 1 does not show any value but formula includes

ALL (availability)  etc.

 

Thanks for the efford 🙂

  • talespin's avatar
    talespin
    Icon for Solution Sage rankSolution Sage
    2 years ago

    hi boraJustmop ,

     

    If I understand correctly, I don't think measure is the problem.

     

    You have interaction enabled between slicer and table visual. Disable the interaction and that way you can control which slicer impacts which visual.