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

       

      • v-juanli-msft's avatar
        v-juanli-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi cristianml 

        You could change the measure as below

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

        You could refer to some similar threads:

        Incorrect measure total

        Dealing with measure total

         

        We can't reproduce your problem, could you share a simple example file without your privacy information?

         

        Best Regards
        Maggie
        Community Support Team _ Maggie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.