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
Community Support
1 year ago

Hi AlienBI ,

Thanks for reaching out to the Microsoft fabric community forum.

danextian ,

Ashish_Mathur 

Thanks for your prompt response

AlienBI 

Could you please provide sample data that fully represents the issue or question you're referring to? Kindly ensure the data is in a usable format (e.g., Excel or CSV) rather than a screenshot, and does not contain any sensitive or unrelated information.

Looking forward to your response.

Best regards,
Lakshmi Narayana

 

 

AlienBI's avatar
AlienBI
Frequent Visitor
1 year ago

Thanks for your help, I've now shared the link to download the pbix