Limit calculation by period and ticket

[carinatina_pbi]

I am trying to replicate this excel file calculations in PBI file.

So far I could already find some solution using columns, but this works only if I load just one ticket in my database.

If I load more calculation is completed wrong.

The solution should be based on ticket and period.

If the ticket has 6 lines/periods, we should calculate only 5 columns (Col 1, Col 2 ...) as below (not filling all lines):

But as it has been created, if I load more than one ticket, I got figures wrong as below (yellow marked ones should not appear):

There is any possibility to have it correct calculated/limited even loading more than one ticket?

Thanks in advance for any help.

Carina

[lbendlin]

You may not want to name your measures Col1, Col2 etc - that might be confusing.

If you want to suppress the display for  certain cells you will need to modify the respective measure to return BLANK()  for these contexts.