Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Refering to Variable Column - Simple Case

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 2...
  • camargos88's avatar
    camargos88
    6 years ago

    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
     

     

     

camargos88's avatar
camargos88
Community Champion
6 years ago

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