Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

drillthrough issue

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

Need Help
Tips and Tricks

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Anonymous ,

     

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

     

    Regards,

    Jimmy Tao

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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