Forum Discussion

Rikin-Nayak-007's avatar
Rikin-Nayak-007
Frequent Visitor
3 years ago
Solved

Multiple dates issue in single graph

How to use DAX to create a relationship on a specific graph with an inactive date after overriding the effects of an active relationship date on the same graph. I have item names on the x axis of th...
Need Help
  • Rikin-Nayak-007's avatar
    Rikin-Nayak-007
    3 years ago

    I found the solution as make all relations with Calender table inactive. Wherever necessary, construct active relations using the DAX formula USERELATIONSHIP.

TomMartens's avatar
TomMartens
Super User
3 years ago

Hey Rikin-Nayak-007 ,

 

I have to admit that I do not understand your requirement.

I assume that there is a slicer that filters the year ('date'[date]), as no date is involved on the chart.

I also do not understand the measure you provided, as it does not contain an aggregate function for the first parameter, the numeric expression. I think it has to look like this:

CALCULATE(
    COUNT( 'master'[item] )
    , ...
)

Maybe it should look like this to calculate the sales value with the change of the relationship:

CALCULATE(
    SUM( '<the name of the sales fact table>'[<sales valuue>] )

    ,USERELATIONSHIP('Date'[Date],Master[Selling_date]))

)

But as I mentioned, I do not exactly understand your requirement.
Consider creating a pbix that contains sample data but still reflects your data model (tables, relationships, calculated columns, and measures). Upload the pbix file to onedrive, google drive, or dropbox and share the link. If you are using Excel to create the sample data instead of the manual input method, share the Excel file.
Please elaborate on the problem you are facing based on your sample data.

Regards, 

Tom