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.
I have a chart displaying a line graph that is showing total credit hours from the years 2014 - 2023. All of the data is consolidated into one table and was derived from a manual forcast in Excel. I've paired this with a 'what if' parameter that adjusts the total credits per year if the average per student credit is increased by whatever the user selects on the slider.
All of that is working perfectly but the parameter adjusts the value for the full 10 year span and I'd like it only to adjust for 2019-2023 becasue that is really the only point in time which the credit hours could feasibly change.
I have a total credits field that is based upon the average credit hours from the table and then a separate total credits field that is generated by the what if parameter. My thougth was that if I could create some kind of filter variable that would combine the two into one measure I could use that in the display - but I keep getting errors. Something along the lines of (but I struggle with my if statements and can't seem to not get an error of multi value or too many arguments)
Solved! Go to Solution.
This is the formula I finally got to work:
Hi @ahumke,
Could you please share some sample data to have a test and post your desired result if possible?
Regards,
Daniel He
Here is the sample data.
From this point, the average credits need to have a measure created.
This is the formula I finally got to work:
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |