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.

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

Here Why Item 4 Not appear in column chart ? My sampe data is 

And for column chart I used following expression for x - axis value:

Item_DAX =
Var slicer2 = SELECTEDVALUE(Sheet1[Status as on 2020])
Var Items_Dax =  IF(slicer2="Selling",CALCULATETABLE(DISTINCT(Sheet1[Item]),ALL(Sheet1[Purchase Date]),USERELATIONSHIP(Calender[Date],Sheet1[Selling Date])),CALCULATETABLE(DISTINCT(Sheet1[Item])))
return Items_Dax
TomMartens's avatar
TomMartens
Super User
3 years ago

Hey Rikin-Nayak-007 ,

 

please  provide a pbix that contains sample data, but still reflects your data model, tables, relationships, calculated columns and measures.

You measure Item_DAX does not return a scalar value.

Next you need a table dimension table, that contains only the items.
Based on the data distribution item 4 can not return if you only have the sales table. I recommend reading this article: Understanding DAX Auto-Exist - SQLBI

Regards,
Tom