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 ,

 

please provide a pbix file that contains sample data, but still reflects your data model.

You can not create a measure that returns a table.
A measure can only return numeric values, a scalar value. It is possible to leverage virtual tables during the calculation of a measure, though.

 

I'm also wondering about your expectation if option1 is selected from the 2nd slicer, are there two bars for one item?

Please share the pbix and also the DAX measure used to represent the numeric values.
If you are talking about bars, horizontal rectangles where the width is used to represent the numeric values, if you are talking about columns, then the height of a vertical rectangle is used for data visualization.

Regards,

Tom

 

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