One Measure With Different Calculations Depending on Matrix Row Group Value

Hi everyone,

I need to add three extra categories or groups at the bottom of a matrix and do a different calculation for them.

For example, let's say I have a matrix with one category/group "Car Make" and one value which displays a count.

The matrix would look something like this:

"Car Make" populates the matrix dynamically, depending on availability, but the bottom three rows/groups are fixed and need to be displayed always.

For this reason, I have created a new table which generates only one column with distinct values for car make, plus I manually added the three rows to that table.

I was hoping to create a measure with an IF or SWITCH statement that checks matrix group name and then calculates appropriately, but this obviously doesn't work:

Measure = CALCULATE(IF(SELECTEDVALUE(CarMakeUnion[name])="---TOTAL---"; SUM(CarMakeUnion[count]); COUNT(CarMakeUnion[name])))

Is it possible to do something like this?

Or should I take a different approach?

I need to have it in only one matrix, however.

Any help is appreciated.

Thanks and best regards,

Mike