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.
Hello,
I'm trying to find a way to display the best historical preformance for some company metrics. The data is from a SQL server and comes in two parts. A numerator value and a denominator value. However, there are multiple values per work day and in order to be accurate, the numerators and denominators from a specific work day must first be summed before being divided.
Currently, I am able to display the data by creating a relationship to a table that is a list of individual work days so by creating a 1:Many relationship I can do the calculation using a measure (shown below)
Solved! Go to Solution.
Hello @Anonymous,
1. Create a measure to calculate the numerator and denominator sum for each work day:
NumeratorSum = SUM(AHS_SHM[Cycle_Time_Numerator]) DenominatorSum = SUM(AHS_SHM[Cycle_Time_Denominator])
2. Create a measure to calculate the SHM value using the numerator and denominator sums:
AHS SHM CT = DIVIDE([NumeratorSum], [DenominatorSum], 0)
3. Create a measure to find the all-time maximum SHM value:
MaxSHM = MAXX(ALL('AHS_SHM'[WorkDay]), [AHS SHM CT])
Let me know if you might need further assistance.
Hello @Anonymous,
1. Create a measure to calculate the numerator and denominator sum for each work day:
NumeratorSum = SUM(AHS_SHM[Cycle_Time_Numerator]) DenominatorSum = SUM(AHS_SHM[Cycle_Time_Denominator])
2. Create a measure to calculate the SHM value using the numerator and denominator sums:
AHS SHM CT = DIVIDE([NumeratorSum], [DenominatorSum], 0)
3. Create a measure to find the all-time maximum SHM value:
MaxSHM = MAXX(ALL('AHS_SHM'[WorkDay]), [AHS SHM CT])
Let me know if you might need further assistance.
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 |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |