Forum Discussion

AlienBI's avatar
AlienBI
Frequent Visitor
1 year ago
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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    Hi,

    Try these steps:

    1. In Power Query, create a master list of all unique RegionClass entries
    2. Create a Many:1 relationship from the Regionclass column of DemandPlotterRA table and Fleet-All Locations table to the table created in 1 above
    3. Delete the relationship between DemandPlotterRA table and Fleet-All Locations table
    4. Create a relationship between the relevant date column of the DemandPlotterRA table to the Calendar table.
v-lgarikapat's avatar
v-lgarikapat
Icon for Community Support rankCommunity Support
1 year ago

Hi AlienBI ,

I wanted to follow up and confirm whether you’ve had the opportunity to review the information  provided by Ashish_Mathur , danextian  If you have any questions or need further clarification, please don’t hesitate to reach out.

we would be glad to support you.

 

Best Regards,

Lakshmi