Forum Discussion

Swathykorivi's avatar
Swathykorivi
Helper I
4 months ago
Solved

Need help to create Calculation in DAX

Method 1 BalanceTiers = VAR Bal = COALESCE('custdataMLY'[Balance Amount],0) RETURN SWITCH( TRUE(), Bal <= 0, "<=$0", Bal <= 100, "$0-$100", Bal <= 500, "$100 - $500K", Bal <= 1000, "$500 - $1K", B...
Need Help
  • mickey64's avatar
    mickey64
    4 months ago

    For your reference.

     

    Step 0: I use these data below.

    <DATA>

     

    Step 1: I make a measure and two matrixs.

    Balance Tiers = IF(SUM(DATA[Balance])<= 0, "<=$0",
        IF(SUM(DATA[Balance])<= 100, "$0-$100",
        IF(SUM(DATA[Balance])<= 500, "$100 - $500",
        IF(SUM(DATA[Balance])<= 1000, "$500 - $1K",
        IF(SUM(DATA[Balance])<= 2000,"$1K - $2K",
        IF(SUM(DATA[Balance])<= 5000, "$2K - $5K","$5K+"))))))

     

    By the way, there are many mistype in your text.

    Bal <= 0, "<=$0",
    Bal <= 100, "$0-$100",
    Bal <= 500, "$100 - $500K",
    Bal <= 1000, "$500 - $1K",
    Bal <= 2000, "$1K - $2K",
    Bal <= 50000, "$2K - $5K",
    "$5K+"

     

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 months ago

Hi,

Not clear about what you want.  Based on the data that you have selected, show the expected result.

Swathykorivi's avatar
Swathykorivi
Helper I
4 months ago

Ashish_Mathur I have added the expected output pic in the post below