Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Team,
Need help in SSAS tabular model
I am having one product table with the below details:
I have created one custom table in SSAS
DEFINE TABLE Ranges= DATATABLE (
"Ranges", STRING,
"Min Range", INTEGER,
"Max Range", INTEGER,
{
{"0-10", 0, 10 },
{ "10-30",10, 30 },
{ "30-60",30, 60 },
{ ">60",60, 100 }
}
)
EVALUATE Ranges
I need to get the range from range table based on the below condition
i
product[sales]>minrange && sales <max range then range
final output table:
Thanks In Advance
Solved! Go to Solution.
Hey @Anonymous ,
the following calculated column should do that:
Range =
VAR vRowSales = 'product table'[sales]
RETURN
CALCULATE(
MAX( Ranges[Ranges] ),
Ranges[Min Range] < vRowSales && vRowSales <= Ranges[Max Range]
)
Be aware that you are not clear with your definition of the beginning/endings of the ranges. As a user I would expect the sales of 10 to appear in both ranges (0-10 and 10-30) as both include 10.
Maybe you should do the ranges like 0-10, 11-30, 31-60, >60
Like this it would be clear in which range which number belongs to.
Hey @Anonymous ,
the following calculated column should do that:
Range =
VAR vRowSales = 'product table'[sales]
RETURN
CALCULATE(
MAX( Ranges[Ranges] ),
Ranges[Min Range] < vRowSales && vRowSales <= Ranges[Max Range]
)
Be aware that you are not clear with your definition of the beginning/endings of the ranges. As a user I would expect the sales of 10 to appear in both ranges (0-10 and 10-30) as both include 10.
Maybe you should do the ranges like 0-10, 11-30, 31-60, >60
Like this it would be clear in which range which number belongs to.
User | Count |
---|---|
20 | |
18 | |
17 | |
11 | |
7 |
User | Count |
---|---|
28 | |
28 | |
13 | |
12 | |
12 |