Forum Discussion

rickferreiran's avatar
2 years ago

Drill through working Dynamically

Hello,
I have a problem that I will describe.
I have a fact table with rows and each row has a open date, end date and closure date.
I have a dimdate anda there is no relationship between this two tables.
I create a measure selected date: The selected date need to be by defaults the dateinsert-30 days.

selected_date: IF( ISBLANK(SELECTEDVALUE(DimDate[Date])), LASTDATE(F_Table[DateInsert]) - 30, SELECTEDVALUE(DimDate[Date]) )

 The selected date is set up this way if I want to select another date:

 


I create a measure:

Nt=Calculate(Countrows(F_Table), FILTER(ALL(F_Table),F_Table[opendate] >= F_Table[selected_date]))

 The measure works well, but when I am trying to Drill through to a new page with a table with all records that I found in Nt, the table show all records from the table and not what is suppose to do. 
I am putting the measure on Drill through but it seems that the selected date in not taking in acocunt.

Anyone knows hoe to solve this?

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi rickferreiran ,

    Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.Thank you.

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.