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.
I have a measure called SumOfMonth and it is the Sum of 2 other Measures.
I have a Matrix Table that uses Months for Row and is filtered by a slicer. I wanted to get the Average of SumOfMonth and Display it on a Card,
My Initial thought is to use Average and put the Measure name but it doesn't accept it. I'm really new to DAX and I can't figure out how to achieve this.
Thank you
Solved! Go to Solution.
If you create a measure:
[Avg of SumOfMonth] =
AVERAGEX(
DISTINCT( T[Month] ),
[SUMMonth]
)
it'll do what you want. If, for instance, you put it on the matrix, for each individual month it'll display [SUMMonth] and the total row will show you the average across the months in the matrix. Put the measure on a card and you'll get the average as well.
If you create a measure:
[Avg of SumOfMonth] =
AVERAGEX(
DISTINCT( T[Month] ),
[SUMMonth]
)
it'll do what you want. If, for instance, you put it on the matrix, for each individual month it'll display [SUMMonth] and the total row will show you the average across the months in the matrix. Put the measure on a card and you'll get the average as well.
Thank you so much @Anonymous it worked liked a charm!
Below is my Sample, apologies I can't share a PBIX, So I added the measure Escalweight and Challengeweight to get SUMmonth then I wanted to display 2.25 as the average on a card.
Hope this is clear.
@justnoob08 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Covering 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 |
---|---|
41 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
42 | |
39 | |
33 | |
19 | |
18 |