Forum Discussion

Rakesh_508's avatar
Rakesh_508
Helper I
2 years ago

undefined

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.

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

  • Rakesh_508's avatar
    Rakesh_508
    Helper I
    2 years ago

    Anonymous 
    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        Rakesh_508
        Helper I
        2 years ago

        Anonymous 

        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???