Hi Team,
I am having one table with below details
and i am defining one table in ssas for Ranges
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

Final output:

Ranges should compare with min and max range from ranges tables . These two table doesn't have relationships.
[2]: /answers/storage/attachments/125408-ranges.jpg