Forum Discussion

justinMcC's avatar
justinMcC
Frequent Visitor
8 years ago
Solved

Measure to x axis chart or dymanic table

Hi,

 

 

I have a using a table, measure and slicer to categorise my data. I need to create a chart showing the result of measure, which I need to update when user changes value of slicer. Below is sample data

 

Table:

Clients     Min_eligible

client_1    10

client_2    20

client_3    30

 

Slicer:

10

20    (eg selected value)

30 

 

Measure:

IF min_eligible < slicer, 'partical' else 'full'

 

Result:

Clients     Min_eligible    Measure

client_1    10                   Partial

client_2    19                   Partial

client_3    30                   Full

 

I need to create a clusterd chart showing measure and count of clients, ie

 

Full        1

Partial    2

 

I need the above result to auto update if the end user changes the selected value in slicer. Is there any way I can create a dynamic column or table from the above. The main requirement I have is that it needs to update on slicer selection change.

 

Thanks for your help

 

Regards

 

JustinMc

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    justinMcC,

    I make the following  table using your sample data.


    Create the following measures in the first table.
    Measure  = IF(MAX(Table1[Min_eligibe])<MAX(Table2[Column1]),"partical","full")
    partical = CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[Min_eligibe]<MAX(Table2[Column1])))
    full = CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[Min_eligibe]>=MAX(Table2[Column1])))

    Create visuals as shown in the following screenshot.


    Regards,
    Lydia

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    justinMcC,

    I make the following  table using your sample data.


    Create the following measures in the first table.
    Measure  = IF(MAX(Table1[Min_eligibe])<MAX(Table2[Column1]),"partical","full")
    partical = CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[Min_eligibe]<MAX(Table2[Column1])))
    full = CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[Min_eligibe]>=MAX(Table2[Column1])))

    Create visuals as shown in the following screenshot.


    Regards,
    Lydia

    • justinMcC's avatar
      justinMcC
      Frequent Visitor
      8 years ago

      Thanks Anonymous

       

      I used a modified version of your DAX formula. It worked great, thanks for your help - it really helped me out with customer issue