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.

savannahr's avatar
savannahr
Regular Visitor
2 years ago

Expected would be the net difference of total responses minus the team 1 and team 2 ones listed in other something like below. 

 

Customer    Total Responses     Team 1     Team 2     Other

Stan             10                           2                5             3

Ann             15                           6                4              5

Bill               12                           8                1             3

 

Hope this helps. 

savannahr's avatar
savannahr
Regular Visitor
2 years ago

Greg_Deckler did not at mention you in response apoligies.