Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@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
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.
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???
Hi @Rakesh_508 ,
Please share your sample data in text form.
Best regards,
Community Support Team_ Scott Chang
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
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
112 | |
96 | |
94 | |
64 | |
58 |