Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX measures when there are two date columns

Hi All,   I'm facing an issue in creating a measure using 2 date columns in the dataset. Overview of the dataset: Sales DocumentCreated OnDefect typeDefect dateCountry 1 3/1/2021 Internal D...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks a lot!!
    It's working perfectly 🙂

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Use a calendar table

Connect the date from the calendar table to the "created on" date with an active connection

Connect the date from the calendar table to the "defect date" with an inactive connection.

 

 

Use the DAX function USERELATIONSHIP() in your measures to switch relationships on the fly.

 

 

 

 

"If I use the Defect filter date the defect % should be total defects/orders created on the defect date".

This is unclear. Please show the expected outcome. 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi,

Thank you for reply.I'm able to get the defect % that you mentioned above using the measure that I have created.This gives me how many of the orders logged on 3/1/21 turned out out to be defective - 71.4%
My real issue is when I select a date from defect type filter, it should give me the % of defect out of all the orders created on the selected defect date.
Based on created on date - on 3rd March I had 7 orders and 5 were logged as defects

 

Based on defect date filter :

Is this kind of calculation possible?