DAX Power BI

[Codinghiwot]

Hello,

is there any way to ignore slicer using Calculated but no aggregate function? like SUM, COUNT

I am trying to get date values from my date column as they are and without being filtered.

below is what I tried but doesn't give what I want

Owned = Calculate(Values(TableName[Column]), ALLEXCEPT(TableName, TableName[Column], TableName[Column]))

[v-qiuyu-msft · Accepted solution]

Hi @Codinghiwot ,

You can create a measure below: 

Measure = CONCATENATEX(ALL('Table1'),CALCULATE(VALUES(Table1[Date])),",")

Or you can set the table visual will not be filtered by the slicer visual via Edit Interactions feature: 

Best Regards,
Qiuyun Yu