Forum Discussion

savannahr's avatar
savannahr
Regular Visitor
2 years ago
Solved

Except Function

I have a table going to show example below but i need to use a countif almost statement excluding certian data. Not sure how to do it.    So example below i have customers and i can calculate for t...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi savannahr ,

    Since you didn't provide your data model, I could only calculate all the fields in one table.

    Below is my test table:

    Please try to create a new column with below dax formula:

    Other = [Total Responses]-[Team 1]-[Team 2]

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_Binbin Yu
    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
2 years ago

Hi savannahr ,

Since you didn't provide your data model, I could only calculate all the fields in one table.

Below is my test table:

Please try to create a new column with below dax formula:

Other = [Total Responses]-[Team 1]-[Team 2]

Please refer the attached .pbix file.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.