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, Newish to BI so help would be much appreciated 🙂
I have a calculated measure in a table in PowerBi desktop report, to create some customer brackets based on Cash flow over past 30 days.
This measure is generated with inputs that can be adjusted via sliders to indicate & increases, which impact on the adjusted cash bracket
However I need to turn use this measure data in a matrix/chart and I cannot use the measure on the legend or axis on chart.
Here is what the table looks like at a customer level.
The last column is the measure I have created, based on the following DAX
Hi Matt_Mcmillin,
You should know calculated column is different from measure, they refer to different context. And calculated Column can't based on slicer context. You need to use measure to achieve this goal. You could inform me more detailed information (such as your sample and your expecting output).
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I have looked at this again and have tried to create a column that references the Measure( "Cash Bracket Adjusted") and uses Variables as per the DAX below
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 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |