Forum Discussion
Solved
DAX Power BI
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]))
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
1 Reply
v-qiuyu-msftCommunity Support
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