Forum Discussion

ruxandraalina's avatar
ruxandraalina
Icon for Helper I rankHelper I
3 years ago

Ignore relationship between two tables

Hello,    I have a date dimension table and a fact table with ticket information - there is a relationship between the Date table and the Created Date from the fact table.    On a specific page, ...
Need Help
  • ruxandraalina's avatar
    ruxandraalina
    Icon for Helper I rankHelper I
    3 years ago

    Hi Greg_Deckler 

    Thanks! I actually tried it before submitting this post, but it's not giving the intended result. 

     

    The first two tables use Created Date and Closed Date from the fact table, while the third one uses Month from the dimension table. 

     

    To double check the results, I have created an additional simple formula (# Tickets with Pos Feedback v2) that is not connected to the relationship. The point was to double check whether the results in the middle table or equal to the results in the last table, but they are not. 

     

    Is there anything wrong in my DAX formula for the third table?

     

    # Tickets with Positive Feedback = 
var ctx_date = values('[F] Date'[Date])
return
CALCULATE(
    DISTINCTCOUNT(Incidents[Number]), 
    USERELATIONSHIP(Incidents[CompletionDate_clean], '[F] Date'[Date]),
    FILTER(
        Incidents,
        //ALLSELECTED(Incidents), 
        Incidents[completionDate] <> BLANK() 
        && Incidents[CompletionDate_clean] in ctx_date
        && Incidents[feedbackRating] in {4, 5}
        && Incidents[CSAT Is Valid for SD] = TRUE()
        //&& USERELATIONSHIP(Incidents[CompletionDate_clean], '[F] Date'[Date])
        //CROSSFILTER('[F] Date'[Date], Incidents[CallDate_clean], None)
        //REMOVEFILTERS('[F] Date')