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

[Anonymous]

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?

[amitchandak]

@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]

@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

[amitchandak · Accepted solution]

@Anonymous , have you created calculation groups in tabular editor?

then something is wrong, because when you take group name, you should see all 4

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

[Anonymous]

@amitchandak I created the calculation group exactly as in the link you sent, with tabular editor.

It still does not work

[Anonymous]

@amitchandak Thank you, I'll take a look at the calculation groups again!

You are awesome!