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 dynamically selected slicer values (eg: Budget V1 and Budget V2) are not being pulled into the calculated table.

 

Below is the snaphot of the dax formula. Not sure where am i going wrong. 

 

Please help

 

Need Help

3 Replies

  • 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

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    4 years ago

    Hi, Shinu1 

    May I ask if your problem has been solved? Is the above post helpful to you?

     

    It makes it easier to give you a solution.

    1. Sample (dummy dataset) data as text, use the table tool in the editing bar
    2. Expected output from sample data
    3. Explanation in words of how to get from 1. to 2.

    How to Get Your Question Answered Quickly

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.