Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |