I want to filter with rating as per below
Total Sales < 8000 = 1
Total Sales 8000 to 10000 = 2
Total Sales > 10000 = 3
I have created new column with follwing filter and it is not working.
When you say "and it's not working", just what is it doing ?
You might consider creating a "helper measure"
Calc_Total = CALCULATE(SUM(Trans[Price.PRICE]),ALLEXCEPT(Trans,Trans[CUSTNUM1])
and put that in your table and see if it's returning the answers you expect.
If so, you can use it to calculate your column.
If you are interested in turning your 3 categories into a slicer, you could use the "parameter table" pattern https://www.daxpatterns.com/parameter-table/
Measure = var _SumPrice = CALCULATE(SUM(Trans[Price.PRICE]),ALLEXCEPT(Trans,Trans[CUSTNUM1]) ) RETURN SWITCH(TRUE(), _SumPrice < 8000 , "1", _SumPrice > 8000 && _SumPrice < 10000, "2", "3" )
HI @SWEZIN ,
Try this measure
var a = CALCULATE(SUM(Trans[Price.PRICE]),ALLEXCEPT(Trans,Trans[CUSTNUM1]
a >= 10000, "3",
a <10000 && a >= 8000 ,"2",
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
@SWEZIN , see you are lloking for segmentation , refer
Measure = VAR FilteredPrice = CALCULATE ( SUM ( Trans[Price.PRICE] ), ALLEXCEPT ( Trans, Trans[CUSTNUM1] ) ) RETURN SWITCH ( TRUE (), FilteredPrice < 8000, "1", FilteredPrice > 8000 && FilteredPrice < 10000, "2", // default case "3" )
Christopher Pollock @ LinkedIn
If this post helps please consider "Accept it as the solution" to help the other members find it more quickly.
⚡Vist us at https://www.bireel.com/ for courses, development and consulting purposes⚡