Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |