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.

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
6 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.