Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
Ref example table below. Various numeric metrics for each month - there are about 30 total columns similar to the examples (events, defects etc.)
Date | events | defects | delays | cycles | defects/cycles |
Jan-22 | 111 | 92 | 32 | 2431 | 0.038 |
Feb-22 | 117 | 85 | 9 | 2162 | 0.039 |
Mar-22 | 40 | 74 | 33 | 2356 | 0.031 |
Apr-22 | 60 | 73 | 38 | 2820 | 0.026 |
May-22 | 122 | 89 | 13 | 2320 | 0.038 |
Jun-22 | 92 | 71 | 40 | 2140 | 0.033 |
Jul-22 | 41 | 91 | 21 | 2617 | 0.035 |
Aug-22 | 106 | 73 | 30 | 2830 | 0.026 |
Sep-22 | 53 | 63 | 24 | 2968 | 0.021 |
Oct-22 | 38 | 60 | 17 | 2906 | 0.021 |
Nov-22 | 148 | 62 | 6 | 2055 | 0.030 |
Dec-22 | 110 | 60 | 28 | 2887 | 0.021 |
Jan-23 | 130 | 62 | 40 | 2513 | 0.025 |
Feb-23 | 132 | 90 | 26 | 2198 | 0.041 |
Mar-23 | 117 | 99 | 29 | 2655 | 0.037 |
Apr-23 | 39 | 85 | 39 | 2018 | 0.042 |
May-23 | 66 | 84 | 28 | 2947 | 0.029 |
Jun-23 | 141 | 95 | 22 | 2313 | 0.041 |
Jul-23 | 62 | 82 | 15 | 2581 | 0.032 |
I'd like to calculate ratio's between the columns based on user-input - I'm imagining two filters titled Numerator & Denominator. The two filter values are passed to a Measure(?) that then calculates the ratio for each row. In the above example the user would have selected 'defects' in the Numerator filter and 'cycles' in the Denominator filter. That result is then plotted in a line chart over time.
I know I can create loads of calculated columns to do this up-front for all the possible combinations, but was wondering if possible to do this dynamically based on user input?
I've looked at other similar articles but they don't quite fit what I'm after - any help appreciated.
Thanks
Solved! Go to Solution.
@bcmoulam , This is the old measure slicer way, You have to create two such tables and slicer and then create combined measure using a divide
How to create a Measure Slicer: https://youtu.be/b9352Vxuj-M
Perfect, thanks Amit!
@bcmoulam , This is the old measure slicer way, You have to create two such tables and slicer and then create combined measure using a divide
How to create a Measure Slicer: https://youtu.be/b9352Vxuj-M
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |