drillthrough issue

[Anonymous]

Hello, 

i have a matrix, and when i do a drillthrough to viu the records from the calculations formulas ...

And the formulas i use is : 

ppppp = var crossfilterproblem = CALCULATE (
          SELECTEDVALUE(PRO_PROD[OPENED_DATE]), 
          CROSSFILTER('Calendar'[Date], PRO_PROD[OPENED_DATE], none)
)
return
if(
    CONTAINS(DATESYTD('Calendar'[Date]), 'Calendar'[Date], crossfilterproblem) || CONTAINS(SAMEPERIODLASTYEAR('Calendar'[Date]), 'Calendar'[Date], crossfilterproblem),
                    CALCULATE(
                        [# of Open  Prob],
                        CROSSFILTER('Calendar'[Date], PRO_PROD[OPENED_DATE], none)
                    )
)

the measure works fine for 2019 but not for 2018 because i set the same period from last year, but i want to show the tickets that are open from 2018.

can anyone help me ? 

Best Regards, 

JO

[v-yuta-msft]

@Anonymous ,

Could you please share some sample data and show the expected result?

Regards,

Jimmy Tao

[Anonymous]

Hello @v-yuta-msft ,

the expected result is to show me the tickts that are open in that time i selected..... i can't show any data truly sorry about that 😞

but... the measure can show a lot because when i selected the time from a matrix visual i do a drillthrough and he show me the ticktets that are open in that time but only show me the ticktes from 2019, and don't pull the records from 2018.

can you please help me ?

Thanks for your response

Best Regards,

JO