Forum Discussion

JohnCarl45's avatar
JohnCarl45
Helper I
2 years ago
Solved

Filtering Two Categories in a column

Hi folks, good day. Can you help me to filter two name categories in the Account Column: "Service Income—SC" and "Service Income—External" to show the value of the remaining categories in the Account...
Need Help
Tips and Tricks
  • v-jincheng-msft's avatar
    v-jincheng-msft
    2 years ago

    Hi JohnCarl45 ,

    Hi, thanks for the information you have given.

    To show the value of the remaining categories in the Account Column, you can use the DAX as follow:

    Amount_ = var _t=CALCULATETABLE('Table', NOT('Table'[Account] IN {"Service Income - SC", "Service Income - External"}))

RETURN MAXX(_t,[Amount])

     

     

     

     

     

    An attachment for your reference. Hope it helps!

     

    Best regards,
    Community Support Team_ Joseph Ji

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Chakravarthy's avatar
Chakravarthy
Resolver II
2 years ago

JohnCarl45 Please try to create measure like this 

Total of Account =
CALCULATE(SUM('Table 1'[Amount]),
  FILTER('Table 1','Table 1'[Account] IN {"PHIC Contributions-COS","Allowances - Medical-COS"})
)
Pull the Account column and this measure you will see the output as below

Hope this helps

  • JohnCarl45's avatar
    JohnCarl45
    Helper I
    2 years ago

    Hi sir, good day. Thanks for the reply. I really appreciate it. Can you filter all the categories in the account column except for the two names in the account column, which are "PHIC Contributions-COS" and "Allowances-Medical-COS"? I really want to show all categories, except for two, because in the original data, there were almost 100k rows in Excel, so I want to show all the categories in the account, except for two.