undefined

[Rakesh_508]

HI

I do have a scenario where I have used Field parameter in the Rows of a matrix visual.
I do have a year column in columns of a matrix which has values of 2023,2024,2025..(2024 future data +2025 data is coming from forecast table and 2023 and 2024 upto date  data is coming from actual table) 
I do have Goal and completed measures in the values section to show the Goal and completed values of the rows section based on year including actual and future values.
my requirement is that I want to show the sum of total values of 2023,2024,2025 as a seperate column and pecentages of goal and completed of the total as a seperate column..
I have tried enabling column subtotal to show summation of all those above years but its showing 0 value.

[Rakesh_508]

@v-tianyich-msft 
Please see the below measures which used in the matrix table

Goal measure=

var currentyear=selectedvalue(DateTable[Year])
var Actual=Calculate(Countrows(ActualTable),ActualTable[Year]=currentyear)+0
Forecast=Calculate(countrows(ForecastTable),Year(ForecastTable[NextDueDate])=currentyear)+0
return
Actual+Forecast

Completed measure=

var currentyear=selectedvalue(DateTable[Year])
var Actual=Calculate(Countrows(ActualTable),ActualTable[Year]=currentyear,ActualTable[Status]="Completed")+0
Forecast=0
return
Actual+Forecast

[v-tianyich-msft]

Hi @Rakesh_508 ,

Your requirement is to calculate the sum, why use countrows, try using the sum function

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Rakesh_508]

@v-tianyich-msft 

I tried and could not able to use sum insted of countrows....Can you please help me out on Goal and Completed measures using sum???

[v-tianyich-msft]

Hi @Rakesh_508 ,

Please share your sample data in text form.

Best regards,
Community Support Team_ Scott Chang

[v-tianyich-msft]

Hi @Rakesh_508 ,

Do you use the min function in your measure, please provide sample data and your measure expression.

Best regards,
Community Support Team_ Scott Chang