Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 [Materialty] = CEM)
RMQ Recipes:
Material list(sample):
Relationship:
This doesnt work as expected:
If I calculate the average by myself it should be 161,25 (see last picture) - my measue shows me 170.
Maybe someone can help me out with an additional question: Why have the values for "Wert" values behind the comma as none of them in the source have?
Thanks in advance for having a look into this.
Solved! Go to Solution.
@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.
Oh no.. I think I understand the values now and it seems that all is correct calculated as Amit mentioned. It was my wrong understanding of the calculation, so I added the SUM and the COUNT to follow the "irritation" and that explained it to me...I calculated the wrong column while power bi does calculating the right values.
Thanks for helping me finding the issue 😉
Hi @Pillic ,
Glad to hear that you have found the issue. You may help accept the replies making sense as solution above. Your contribution is highly appreciated.
Best Regards,
Icey
@Pillic - Seems like AVERAGEX(FILTER(RELATEDTABLE(...),...),...)
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?
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.
@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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
63 | |
52 | |
47 |
User | Count |
---|---|
218 | |
86 | |
64 | |
63 | |
60 |