Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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,
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
Thanks @v-yuezhe-msft
I used a modified version of your DAX formula. It worked great, thanks for your help - it really helped me out with customer issue
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |