Forum Discussion
How to Filter data and get record in DAX
I want to filter Worker table in DAX and get data like
Select * from Worker w
where w.Name <> "Once Off"
6 Replies
smpa01Community Champion
Anonymous equivalent DAX query would be
//in SSAS EVALUATE FILTER(Worker, Worker[Name]<>"Once Off") //in PBI Table = FILTER(Worker, Worker[Name]<>"Once Off")- smpa01
Yes there is. Anonymous but how does your data look like? Provide a sample and what is the end goal?
v-yalanwu-msftCommunity Support
Hi, Anonymous ;
If you only want to filter columns in visual or data view, you can directly filter like below:
If you want to use dax, you could create a measure.
flag = IF(MAX('Table'[Name])="Once Off",0,1)then apply it into filter.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.