Forum Discussion
Static data is being assigned a date when plotted on a Line chart due to indirect relationship
I have a table of static data that I am trying to plot on a line chart as a straight line. When this static data table has no relationships, I am able to do this fine. However, as I need to be ab...
Kaviraj11
Solution Sage
Solution SageOnce you have an Inactive relationship. you can create a measure including the inactive relationship -
Example
Orders Shipped = CALCULATE( COUNTROWS(Sales) ,USERELATIONSHIP('Date'[Date], Sales[ShipDate]) )
Active vs inactive relationship guidance - Power BI | Microsoft Learn
Thanks for the response! Definitely an improvement, although it is now only returning the static line for dates up until the current date. Not sure how to get it to bypass date considerations altogether?