Forum Discussion
Solved
My calculated column doesn't work with context when using it on a line chart
Hi there, Relatively new to PowerBI - I've got a little issue hope you can help me with. I created a calculated column called RPD as such: RPD = CALCULATE(DIVIDE(sumx('DemandPlotterRA+RES',DI...
Hi,
Try these steps:
- In Power Query, create a master list of all unique RegionClass entries
- Create a Many:1 relationship from the Regionclass column of DemandPlotterRA table and Fleet-All Locations table to the table created in 1 above
- Delete the relationship between DemandPlotterRA table and Fleet-All Locations table
- Create a relationship between the relevant date column of the DemandPlotterRA table to the Calendar table.
danextian
Super User
Super UserThe possible reason is you created a calcualted column instead of a measure. I don't see repeating numbers in RPD your screenshot so it may not be the reason as well but then what we see is just a chunk of the actual table. It would be easier if we had a copy fo the pbix and then you explain to us what your expected results are for some of the dates.
Yes I did create a calculated column instead of a measure. I tried with a measure but I had a similar result - it wasn't changing with context, the same value applied to all.