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 fut...
Need Help
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???

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Rakesh_508 ,

         

        Please share your sample data in text form.

         

        Best regards,
        Community Support Team_ Scott Chang