Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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"
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago
    Issue resolved.
    CALCULATE(
    SUM(InvoiceLines[Tons]),
    FILTER(InvoiceLines, InvoiceLines[ITEMID] = InventoryStock[ITEMID]),
    Filter(Worker, Worker[WORKERNAME] <> "Once Off")
    )
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago
    Issue resolved.
    CALCULATE(
    SUM(InvoiceLines[Tons]),
    FILTER(InvoiceLines, InvoiceLines[ITEMID] = InventoryStock[ITEMID]),
    Filter(Worker, Worker[WORKERNAME] <> "Once Off")
    )