Refering to Variable Column - Simple Case

[Anonymous]

Hello My Friends,

How Are You?

So I Have a Table Like this:

Travel ID	Motive	Value
1	A	1000
2	A	2000
1	B	1000
1	C	2000
2	B	1000
3	A	3000
4	A	2000
4	B	1000

So, what i need is to take All Travels IDs wich has the same number and SUM it!

If the Sum's Value is between 0 and 1000 Show it as Low Cost

If the Sum's Value is Over 1001 Show it as High Cost

After that I Wanna count how many Low Cost, How Many High Cost Travels i have

Is it possible to do this without creating a New Table? Just creating a New Measure?

I Was trying to create a new measure, than summarize my table and finally do an "If", but i can not refer to my Variables Columns using "IF"

Awnser =

VAR MyVar = Summarize('Table'; 'Table'[Travel ID]; "TOTAL"; Sum('Table'[Travel ID]))

RETURN

If ( MyVar[TOTAL] < 1001 ; "Low Cost"; "High Cost)

[camargos88 · Accepted solution]

Hi @Anonymous ,

First create a table with your ranges:

After create this measure:

Measure =

VAR _tb = ADDCOLUMNS(SUMMARIZE('Table'; 'Table'[Travel ID]; "Total"; SUM('Table'[Value])); "RangeDesc";

SELECTCOLUMNS(FILTER(tb_range; [Total] >= tb_range[Min] && [Total] <= tb_range[Max]); "RangeDesc"; tb_range[DescriptionRange]))

RETURN COUNTX(_tb; [RangeDesc])

I've inputed another value, less than 1000 to try the results.

Did I answer your question? Mark my post as a solution!
Ricardo