Custom row total - changing number of columns

[Anonymous]

Hi,

I struggle with a problem of total value calculations. I want to create a matrix with a few columns. The situation is depicted on the below image. Basicly there are two measures (Measure1 and Measure2). Measure3 is calculated using the expression if(measure1 <> 0, measure2, 0). The final measure consist of a part of Measure2 and Measure3 (green and yellow cells). So far I have used HASONEVALUE but when the number of columns is changing it doen't make sense. I have been using SELECTEDVALUE but it also requires static number of columns in the table (SELECTEDVALUE-link). The goal is to calculate the last column FinalMeasure.

 

Gladly I will hear any suggestions from you on how to cope with this problem.

[v-danhe-msft]

Hi @Anonymous,

Due to I could not figure out your logic of measure 1 and measure 2, I could not test for your data. Could you please offer a sample file to have a test if possible?

Regards,

Daniel He

[Anonymous]

Hi @v-danhe-msft,

finally I have resigned from this logic and implemented without it. I still don't know solution but it's irrelevant right now.

Kind regards,

Nicr