Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello to all,
I have a series of calculated measures and of these measures I would like to make a simple arithmetic average.
Is there someone who can help me?
From [-12 OH] to [-1 OH] are Measures and I need to calculate the Average. In Figure 1 I have full of Data Sets while in Figure 2 I haven't Date in [-12 OH] to [-9 OH]. In the first case the average must correspond on all the measures while in the second case only on the full ones
Hi @GoodMan85,
I suggest you use the matrix table
I create some simple data like the following:
And create a matrix table
The result:
If I misunderstood you meaning, please let me know.
Here is my pbix file you can reference.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @GoodMan85 ,
Try the following code:
Average of measures =
AVERAGEX (
FILTER( UNION (
SUMMARIZE ( table, table[itemcode], "@MeasureTotal", [Measure] ),
SUMMARIZE ( table, table[itemcode], "@MeasureTotal", [Measure 2] ),
SUMMARIZE ( table, table[itemcode], "@MeasureTotal", [Measure 3] )
),[@MeasureTotal] <> BLANK()),
[@MeasureTotal]
)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |