Forum Discussion

C_PriceOH's avatar
C_PriceOH
Frequent Visitor
3 years ago

Remove Table Filters While Using Virtual Table Measures

Hello!   I'm currently trying to return the max value from a virtual table that I will use in another virtual table, along with removing the table filters when I place this max value in a table vis...
Iterator
Max Values
MAXX
Remove Filters
Virtual Table
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
3 years ago

Hi C_PriceOH as I do not understand your exact situation with visuals (do you interact with slicer / filter) please find two possible solution

1. Max Effeciency Score AllSel= CALCULATE ([Efficiency Score], ALLSELECTED()) -- this will include all your selection with slicer / filter

2. Max Effeciency Score All= CALCULATE ([Efficiency Score], ALL()) -- this will NOT include your selection with slicer / filter

 

Hope this help. Kudos appreciate / accept as solution.