Forum Discussion
Need help to create Calculation in DAX
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+"
For your reference.
Step 0: I use these data below.
<DATA>
Step 1: I make a measure and two matrixs.
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+"
mickey64 : i tried taht logic too, but it is showing up $5K+ the last tier
The snapshot date and product type is my slicer
i am using bar charts in theview where i should have balance tiers and Customer count, the logic is only working if i bring teh custid into the view.