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 am written the following Dax formula to calculate the average max words each vendor can do. When I put that formula into my visual and use a date slicer it is slicing my target value and max value in the gauge visual. I only want the slicer to filter words in progress. Can someone help explain how I can accomplish this?
Formula I'm using to get the average This is the formula I am using to calculate the target & max value in my visual
Max words (M) =
VAR Vendor = [Vendor]
RETURN
DIVIDE (
DataDump1[Max Words Per (M)],
CALCULATE (
COUNTROWS ( DataDump1 ),
ALL ( DataDump1 ),
DataDump1[Vendor] = Vendor
)
)
I want the value to change when I slice the date but want to keep the same value for the target and max value.
Thank you for all your help!
Solved! Go to Solution.
Thank you for responding to me. I was able to get the solution. I created a measure and then reference Max words (M) column.
Formula I used was
Max Words (M) Measure =
CALCULATE (
SUM ( DataDump1[Max words (M)] ),
ALLEXCEPT ( DataDump1, DataDump1[Vendor] )
)
And the formula I used for my calculated column to get the average of max words was
Max words (M) =
VAR Vendor = [Vendor]
RETURN
DIVIDE (
DataDump1[Max Words Per (M)],
CALCULATE (
COUNTROWS ( DataDump1 ),
ALL ( DataDump1 ),
DataDump1[Vendor] = Vendor
)
)
Thanks for the help and looking into it for me!
Thank you for responding to me. I was able to get the solution. I created a measure and then reference Max words (M) column.
Formula I used was
Max Words (M) Measure =
CALCULATE (
SUM ( DataDump1[Max words (M)] ),
ALLEXCEPT ( DataDump1, DataDump1[Vendor] )
)
And the formula I used for my calculated column to get the average of max words was
Max words (M) =
VAR Vendor = [Vendor]
RETURN
DIVIDE (
DataDump1[Max Words Per (M)],
CALCULATE (
COUNTROWS ( DataDump1 ),
ALL ( DataDump1 ),
DataDump1[Vendor] = Vendor
)
)
Thanks for the help and looking into it for me!
Hi jarodjp42,
Modify your measure like below and check if it can meet your requirement:
Max words (M) = VAR Vendor = [Vendor] RETURN DIVIDE ( DataDump1[Max Words Per (M)], CALCULATE ( COUNTROWS ( DataDump1 ), ALLSELECTED ( DataDump1 ), DataDump1[Vendor] = Vendor ) )
Regards,
Jimmy Tao
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 |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |