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 am working on a Revenue Dashbaord, and have run into a Brick Wall. I am trying to display Total Revenue and Goal Revenue by individual Units (In this case specific trucks). The problem is there are different Goal's depending on location, and I need my date slicer to impact the results.
I have calculated the Measures that will return the correct Goal value for each of the locations, however when I attempt to pull this data into a single column, everything goes horribly horribly wrong.
I believe the largest problem is that, since I need to be able to have my calculations adjusted by the filter I am unable to use a calculated column, however the location data for each unit is stored by row.
How do I return a measure depending on a value in a row, or is there another direction to attack this problem from?
In the example above, the Projected Revenue would return the $12,427.40 or the $13,847.67 depending on the location of the unit.
Thank you for any help!
Hey @d_jorgensen
You're right that you probably don't want a calculated column. Could you post a snippet of your data so we can try to help you out with your measure?
Thanks,
Parker
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |