Forum Discussion

Shinu1's avatar
Shinu1
Helper II
4 years ago

Calculated Table based on Slicer selection

Hi, I'm trying to get filtered data based on slicer selection into a calculated column. But for some reason only the hardcoded values (eg: Forecast V4) data are only pulled into the table.  The dyn...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Shinu1 , You can not use slicer value in the calculated table.

 

You can have such table as  var in measure and use that

 

measure  =

var _tab =<Table code>

return

sumx(_tab, [Column])

  • Shinu1's avatar
    Shinu1
    Helper II
    4 years ago

    Not sure how to use the slicer selection in sumx.  But i need a table with around 5 column (Account, Cycles, Scenario,Attribute and Amt) having Cycle field filtered based on Slicer selection