Forum Discussion

Pillic's avatar
Pillic
Helper II
6 years ago
Solved

Create a measure based on filter from another table

Hi,   I am lost to find the right measure.   The measue should show, based on selected slicers like plant, CommercialID or Date the average of (RMQ Recipes [Wert]) where (Material list [Materialt...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Pillic , there is nothing wrong with formula. you can use average and check.

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Pillic - Seems like AVERAGEX(FILTER(RELATEDTABLE(...),...),...)

  • Pillic's avatar
    Pillic
    Helper II
    6 years ago

    Hi Greg,

     

    this fails for me:

    CEM Average = AVERAGEX(Filter(RELATEDTABLE('Material list'),'Material list'[Materialty] = "CEM"),'RMQ Recipes'[Wert])

    What am I doing wrong?

    • Icey's avatar
      Icey
      Community Support
      5 years ago

      Hi Pillic ,

       

      How about create another measure like so:

      Measure =
IF (
    [CEM Average] <> BLANK (),
    AVERAGEX (
        ALLSELECTED ( 'RMQ Recipes'[Material] ),
        CALCULATE ( [CEM Average] )
    )
)

       

       

      Best Regards,

      Icey

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.