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.
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
1 year ago

Hi,

Share the download link of the PBI file.  Which of those lines if the problematic one - green or red?

  • AlienBI's avatar
    AlienBI
    Frequent Visitor
    1 year ago

    Sorry first time here! Green line is the issue.
    Here's the link

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      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.