Forum Discussion

arlequin71's avatar
arlequin71
Helper II
8 years ago
Solved

Newbie Question - Time Intelligence Measures Issues

Hello,  I have tried to display MTD, QTR and YTD measures but as shown in the attached image the returned value is zero.  Only when i applied some custiomized time filters values are displayed corre...
  • Seward12533's avatar
    Seward12533
    8 years ago

    Going to need more info to help. Can you share your measures and a picture of the data model?  What period are you trying to show MTD, QTD and YTD in the CARD visuals for? If you want it for now() you will need to write a measure to force some filter context. 

     

    My guess is your measure with the unconstrained filter contect in the Card Visual its using the MAX date in your date table which is way in the future where there is no data.  If your using a straight DAX solution try using the predifined TOTALQTD, TOTALMTD and TOTALYTD functions or are you a raw DAX solution

     

    MTD Sales = 
CALCULATE (
      [Total Sales],
      FILTER (
           ALL ( 'DateTable' ),
                'DateTable'[DateYear] = MAX ( 'DateTable'[DateYear] ) &&
                'DateTable'[DateMonth] = MAX ( 'DateTable'[DateMonth] ) &&
                'DateTable'[Date] <= MAX ( 'DateTable'[Date] ) 
   )
)

     

Seward12533's avatar
Seward12533
Solution Sage
8 years ago

Going to need more info to help. Can you share your measures and a picture of the data model?  What period are you trying to show MTD, QTD and YTD in the CARD visuals for? If you want it for now() you will need to write a measure to force some filter context. 

 

My guess is your measure with the unconstrained filter contect in the Card Visual its using the MAX date in your date table which is way in the future where there is no data.  If your using a straight DAX solution try using the predifined TOTALQTD, TOTALMTD and TOTALYTD functions or are you a raw DAX solution

 

MTD Sales = 
CALCULATE (
      [Total Sales],
      FILTER (
           ALL ( 'DateTable' ),
                'DateTable'[DateYear] = MAX ( 'DateTable'[DateYear] ) &&
                'DateTable'[DateMonth] = MAX ( 'DateTable'[DateMonth] ) &&
                'DateTable'[Date] <= MAX ( 'DateTable'[Date] ) 
   )
)