Forum Discussion
Distinct dax with condition
Hi, I'm getting unique values using Distinct to avoid duplicate list but can I add one conditon from its data table? In the same table 'TOSS serivce PO_master - Append', there's another column '...
Hi Anonymous
Can you please try the below DAX?
VAR FilteredTable = FILTER(
'TOSS service PO_master - Append',
'TOSS service PO_master - Append'[Contract Amount] <> 0
)
RETURN DISTINCT(SELECTCOLUMNS(FilteredTable, "Service No", 'TOSS service PO_master - Append'[service no]))
If this answers your questions, kindly accept it as a solution.
If you found this helpful, then give kudos.Hi Anonymous
As i have tried with sample dataset
DatasetService No.Contract Amount 101 5000 102 7000 103 0 101 3000 104 8000 102 2000 105 0 106 12000 107 4000 108 0 103 0 104 3000 109 5000 I have written the same DAX, and it return the result
Can you please recheck the DAX code you wrote?
oh this creating 2 columns in one go, right?
Now it seems working great
Yes
If I answer your questions, kindly accept it as a solution
If this is helpful then give kudos.