Forum Discussion

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

Hi az38 ,

 

The measure Rate card value is already created but I need to modify this in order to calculate correctly the measure.

 

This is current measure for Rate card value 

 

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

 

But I need to modify this to calculate the average correctly. If helps I need to see the average of the filtered information only, not the average of All. So not sure if the following formulas could help on this situation : if selectedvalue or if filter 

or perhaps we can use the funtion VAR / RETURN 

 

Thanks!

 

 

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

Hello cristianml 

 

I gave the averagex-formula a test and it seems to work nicely


If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun

Jimmy

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

    Hi Jimmy801 ,

     

    I tried to add "RELATED"  but  I couldn't. 

    The table from where comes the Measure Actual LCR  comes from a table that is not a Column, is a category. LCR means Cost rate (marked in yellow in the table) : See the screenshot:

     

    So how can I modify the RELATED in this case so can work properly ?

    Thanks.

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

    Hello cristianml 

     

    sorry, but I can't follow anymore. I don't know the relationship nor do I understand your datamodel. As shown in my examples the measure I proposed is working (to check another column if it's empty or not equal 0. Now you tell me that is category next.

    I'm very sorry, but I'm not able to help anymore

     

    Jimmy