Forum Discussion

donodackal's avatar
donodackal
Helper I
4 years ago
Solved

Help creating new DAX Column

Hi there   The below table is a summary of multiple invoices summed up against the supplier. I would like to create a new column that broadly categories each supplier based on their Total Spend (Th...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi donodackal ,

     

    Please try:

    Categories = 
var _sum=CALCULATE(SUM('Table'[ Total Spend ]),ALLEXCEPT('Table','Table'[Supplier Name]))
return SWITCH(TRUE(), _sum>1000000 ,"million-dollar club",_sum>=200000 ,"200K to 1M club",_sum>=25000 ,"25k to 200k club","Penny value club")

    Output:

     

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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

Share the download link of your PBI file.

  • donodackal's avatar
    donodackal
    Helper I
    4 years ago

    The PBI file has sensitive data.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      4 years ago

      Anonymise the data in the PBI file and share the download link.  Ensure your measures are already written in that file.