Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 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
    5 years ago
    Issue resolved.
    CALCULATE(
    SUM(InvoiceLines[Tons]),
    FILTER(InvoiceLines, InvoiceLines[ITEMID] = InventoryStock[ITEMID]),
    Filter(Worker, Worker[WORKERNAME] <> "Once Off")
    )
Anonymous's avatar
Anonymous
Not applicable
5 years ago

No any trick to filter data in new column/new measure?

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
5 years ago

Yes there is. Anonymous  but how does your data look like? Provide a sample and what is the end goal?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I want this column of Worker table in a single column this is the end goal