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,
need DAX help. I need to find avg values for store which has to remain same irrespective of slicer selection. 3rd column in the below table has same values. can some one pls help on writing DAX to achive this scenario?
store name values
store 1 10
store 2 20
month avg avg slicer selection
Nov-22 15 15 no store sel
Nov-22 10 15 store 1 selected
Nov-22 20 15 store 2 selected
Solved! Go to Solution.
hi @Happy2023_05 ,
If i understand well your ask, you want an average value without matter the filter, you can do that then:
CALCULATE ( AVERAGE ([Values]), ALL( Table Name where is the column of slicer selection, [slicer selection]))
Hi @Happy2023_05 , its simple and i think the below solution will help you.
1. Create a calculated measure -
Avg_revised =
CALCULATE (
AVERAGE (table1[values]),
ALL(table1)
)
Regards,
Nikhil Chenna
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Hi @Happy2023_05 , its simple and i think the below solution will help you.
1. Create a calculated measure -
Avg_revised =
CALCULATE (
AVERAGE (table1[values]),
ALL(table1)
)
Regards,
Nikhil Chenna
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Hi @Happy2023_05 ,
Please Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
hi @Happy2023_05 ,
If i understand well your ask, you want an average value without matter the filter, you can do that then:
CALCULATE ( AVERAGE ([Values]), ALL( Table Name where is the column of slicer selection, [slicer selection]))
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |