Forum Discussion

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

hi cristianml 

without full data model I could only suggest 2 p=issues:

first, correct compare with blank as

Rate Card Value=AVERAGEX(Rate_Card_Table, IF(ISBLANK([Actual LCR]), BLANK(),Rate_Card_Table[Rate Card Value]))

second, replace blank() to 0

Rate Card Value=AVERAGEX(Rate_Card_Table, IF(ISBLANK([Actual LCR]), 0,Rate_Card_Table[Rate Card Value]))

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. Also find below the data Model: 

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

      cristianml 

      Measures_RT_Actual is disconnected from other data models

      whats statement defines [Actual LCR] measure?

      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 ,

         

        Follow the statement for Actual LCR:

        Actual LCR=CALCULATE(AVERAGE(RT_Actual[Quantity]),RT_Actual[Category]="Cost Rate")

         

        I have a measure table to have ONLY measures there. But as you see the "Actual LCR" comes from te table RT_Actual.

         

        Hope this helps