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.
Hey everyone,
I’ve got a simple concept I’m struggling with calculating.
I want to display the $/UOM at a point in time the user selects through the calendar year and apply that rate to the forecast qty
Here’s what I have:
My end goal is to display a bar chart that shows actual $ and forecast $ by month based on which forecast version the user selects (i.e. If user selects Feb forecast, it will show Jan actual $ + Feb thru Dec forecast qty * Jan actual $/IEA to get forecasted $ for Feb thru Dec
Here’s what I’ve got:
What I’m missing
Thanks for your help
Solved! Go to Solution.
Firstly, congratulations on laying out your measures in a table so you can see what’s is happening. This is essential for more complex DAX. You can see that your uom measure is only being returned for month 4 and the total. You need the number to be returned for all months. Stated differently, you need to remove the filter from what ever is causing the measure to only work for month 4. It is probably something like CALCULATE(your current code, all(calendar[month number]))
Firstly, congratulations on laying out your measures in a table so you can see what’s is happening. This is essential for more complex DAX. You can see that your uom measure is only being returned for month 4 and the total. You need the number to be returned for all months. Stated differently, you need to remove the filter from what ever is causing the measure to only work for month 4. It is probably something like CALCULATE(your current code, all(calendar[month number]))
I knew it had to be something simple. Now I can I enjoy the rest of my weekend. Thanks
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |