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.
Hi
I have a value, category column in my table. I need to show some category values as Average and remaining categories as sum.
For example:
Category Unit value
Phones 1 20
Phones 2 30
Watches 1 10
Watches 2 20
Earphones 1 30
Earphones 2 20
Laptops 1 50
Laptops 2 40
Shoes 1 30
Shoes 2 30
Caps 1 10
Caps 2 10
The measure should show values as : Phones,watches,shoes values should be average, rest all should be sum
Phone 25
watches 15
shoes 30
Earphone 50
laptops 90
Caps 20
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
It is for creating a measure.
Expected result measure: =
IF (
HASONEVALUE ( Data[Category] ),
IF (
SELECTEDVALUE ( Data[Category] ) IN { "Phones", "Watches", "Shoes" },
AVERAGE ( Data[value] ),
SUM ( Data[value] )
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Please check the below picture and the attached pbix file.
It is for creating a measure.
Expected result measure: =
IF (
HASONEVALUE ( Data[Category] ),
IF (
SELECTEDVALUE ( Data[Category] ) IN { "Phones", "Watches", "Shoes" },
AVERAGE ( Data[value] ),
SUM ( Data[value] )
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |