How to Pass Slicer selected Value into Calculated column to display the results

[harib]

Hi All,

I have create calculated column in Table A like below, however if i filter Date filed from the dimdate table, calculated column values are not changing. 

Ex :

Calclulate Column = If(Table A[ Category] in {1,2,3} && NOT(Table A [Produts])  in {11,12,13}, [Total_Sales],BLANK())

Total_Sales is a Measure ( Total_sales=sum(Table B(Sales)) ) used in the calcualted column.

Joins : Table A (ID) joined with Table B (ID) and Table B (Date) joined with Dim_Date (Date). 

Can anyone tel me, if  we filter date in slicer, calcualted column should give the values accordingly.

Thanks in Advance.

[PijushRoy]

Hi,

Please change relationship between Fact table and DimDate Table
Date should be filder from DimDate Table to Fact Table
If DImDate Table having Duplicate Date, please make it unique 

If you have any question, please let me know.
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

[v-jayw-msft · Accepted solution]

Hi @harib ,

Inactive the relationship between tableB and dim date then create a measure as below.

Measure =
var tmp = calculatetable(values('tableA'[id]),filter(ALL('tableA'),Table A[ Category] in {1,2,3} && NOT(Table A [Produts])  in {11,12,13}))
return
calculate(sum('tableB'[sales]),filter(ALL('tableB'),'tableB'[id] in tmp&&'tableB'[date] = selectedvalue('Dim date'[date])))

Best Regards,

Jay

[harib]

@amitchandak 

Thanks for the Update.

You mean to say we can't impact the calculated column by selecting the slicer values?.

If not is there any possiblity to create same condition in Measure

(Calclulate Column = If(Table A[ Category] in {1,2,3} && NOT(Table A [Produts])  in {11,12,13}, [Total_Sales],BLANK()))

Thanks

[amitchandak]

@harib , No you can not use a slicer value in a calculated column as of now