Forum Discussion
Distinct dax with condition
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?
Hi Anonymous
Can you please try this?
VAR FilteredTable =
FILTER(
'TOSS service PO_master - Append',
'TOSS service PO_master - Append'[Contract Amount] <> 0
)
RETURN
ADDCOLUMNS(
DISTINCT(SELECTCOLUMNS(FilteredTable, "Service No", 'TOSS service PO_master - Append'[service no])),
"Total Contract Amount",
CALCULATE(
SUM('TOSS service PO_master - Append'[Contract Amount]),
ALLEXCEPT('TOSS service PO_master - Append', '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.
Can you please take a look the error?
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.