Tabula Matrix with Column

[cocoloco79]

Hi 

Is there a way to add a measure or calcuated column, and only apply it to the totals?

For now I have moved them to rows as if I add them to values, It will apply it by size as you can see in the screenshot.

It would already help if you can tell me how I can prevent summing up the % column. There should either be no total or it should max at 100.

I'm stuck with this, but feel there is a solution to it.

Thanks in advance.

[cocoloco79]

Thank you @techies . I applied it but the percentage against each size is calcuated correctly, however the column total shows 30 instead of 100

[techies · Accepted solution]

ok, try using %_Fixed =
VAR IndividualPercent = [Your_Percentage_Measure]
RETURN
IF(
HASONEVALUE('YourTable'[Planting]), 
IndividualPercent,
BLANK() -- Keeps total row blank
)

[Deku]

That soution will still return a value in the subtotal, if a date has a single planting. To avoid this use can ISINSCOPE

VAR IndividualPercent = [Your_Percentage_Measure]
RETURN
IF(
ISINSCOPE('YourTable'[Planting]),
IndividualPercent,
BLANK() -- Keeps total row blank
)

[techies]

Hi @cocoloco79 please try this

%_Fixed =

VAR IndividualPercent = [Your_Percentage_Measure]

RETURN  

IF(

    ISINSCOPE('YourTable'[Planting]),

    IndividualPercent,  

  BLANK()

)