Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Time Intelligence Calculation Group not working with my simple measure - Help

Hello,

 

I have a Time Intelligence calculation group with CY, PY, YoY, YoY %

The calculated group itself its fine, I made it with a tutorial and works with other measures, but not this one:

 

Increase =
VAR CY = 'Measures Table'[Sales]
VAR PY = CALCULATE('Measures Table'[Sales],SAMEPERIODLASTYEAR('Date'[Date]))
RETURN
SWITCH ( TRUE (),PY > 0 && CY > 0 && PY < CY, 'Measures Table'[Sales], BLANK ())
 
It only shows the CY column of the calculation group
How can I fix it?
Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , This does seem like a calculation group?

     

    This measure will give you CY when both CY and PY > 0 and CY > PY

     

    Increase =
    VAR CY = [Sales]
    VAR PY = CALCULATE([Sales],SAMEPERIODLASTYEAR('Date'[Date]))
    RETURN
    SWITCH ( TRUE (),not(isblank(PY)) && PY > 0 && not(isblank(CY)) && CY > 0 && PY < CY, [Sales], BLANK ())

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      amitchandak 
      Here is an image of 2 matrix

      Both of them are using the Time Intelligence calculation group as columns, and Partner Names as rows
      The one on the left uses Sales as Values

      The one on the right uses the Increase meassure mentioned above

       

      As you can see, with the Increase meassure, I can only see one column: CY
      I need to see all the columns of the calculation group