Measure to x axis chart or dymanic table

[justinMcC]

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

[Anonymous · Accepted solution]

@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]

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