Forum Discussion

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

hi cristianml 

try a simple measure

Measure = CALCULATE(
AVERAGE(Rate_Card_Table[Rate Card Value]);
NOT(ISBLANK([Actual LCR]))
)

do not hesitate to give a kudo to useful posts and mark solutions as solution

  • cristianml's avatar
    cristianml
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    Hi az38 ,

     

    Is not working: 

    • az38's avatar
      az38
      Icon for Community Champion rankCommunity Champion
      6 years ago

      cristianml 

      what field do you want to aggregate? Rate Card Value or Actual LCR ?

      Measure = CALCULATE(
AVERAGE(Rate_Card_Table[Actual LCR]);
NOT(ISBLANK([Actual LCR]))
)

      do not hesitate to give a kudo to useful posts and mark solutions as solution

       

      • cristianml's avatar
        cristianml
        Icon for Post Prodigy rankPost Prodigy
        6 years ago

        Hi az38 ,

         

        I want to modify the measure Rate Card Value in order to calculate the correct average.

         

        The Rate Card Value comes from Rate card table and the Actual LCR comes from RT Actual Table. 

         

        Thanks!