cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Codinghiwot Visitor
Visitor

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]))
1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: DAX Power BI

Hi @Codinghiwot ,

 

You can create a measure below: 

 

Measure = CONCATENATEX(ALL('Table1'),CALCULATE(VALUES(Table1[Date])),",")
 
q2.PNG
 
Or you can set the table visual will not be filtered by the slicer visual via Edit Interactions feature: 
 
q3.PNG
 
Best Regards,
Qiuyun Yu 
Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Moderator v-qiuyu-msft
Moderator

Re: DAX Power BI

Hi @Codinghiwot ,

 

You can create a measure below: 

 

Measure = CONCATENATEX(ALL('Table1'),CALCULATE(VALUES(Table1[Date])),",")
 
q2.PNG
 
Or you can set the table visual will not be filtered by the slicer visual via Edit Interactions feature: 
 
q3.PNG
 
Best Regards,
Qiuyun Yu 
Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.