Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
@Anonymous ,
Could you please share some sample data and show the expected result?
Regards,
Jimmy Tao
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
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |