Calculated Table based on Slicer selection

[Shinu1]

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

[v-angzheng-msft]

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.

[amitchandak]

@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]

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