cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NickNg278
Frequent Visitor

Different DAX calculations based on selected values

Hi Community,
I am having an issue creating a measure to make different calculations depending on the cost center selected, below is a sample data

CC     Value
8031
1102
1203
8035

My logic is if 803 is selected on a cost center slicer, it would have a average calculation, if anything that is not 803, then sum of the cost center values. I created the measure below:

 

Test Measure = 
VAR selectedValues =
    VALUES ( Test[Cost Center] )
RETURN
    IF (
        CONTAINS ( selectedValues, Test[Cost Center], "803" ),
        CALCULATE ( SUM ( Test[Value] ), Test[Cost Center] <> "803" ) + CALCULATE ( AVG ( Test[Value] ), Test[Cost Center] = "803" ),
        CALCULATE ( SUM ( Test[Value] ) )
    )

 

This works fine if some values are selected in the slicer; however if none are selected or all values are selected, it would give the wrong calculation. Any directions or help would be really appreciated! 

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

Please try this:

Test Measure = 
VAR selectedValues =
    VALUES ('Table'[CC])
RETURN
    IF (
        CONTAINS ( selectedValues, 'Table'[CC], 803 ),
        CALCULATE(AVERAGE('Table'[value]),ALLSELECTED('Table'[CC])),
        CALCULATE ( SUM ('Table'[value] ) )
    )

Vlianlmsft_0-1624341586024.png

 

View solution in original post

2 REPLIES 2
V-lianl-msft
Community Support
Community Support

Please try this:

Test Measure = 
VAR selectedValues =
    VALUES ('Table'[CC])
RETURN
    IF (
        CONTAINS ( selectedValues, 'Table'[CC], 803 ),
        CALCULATE(AVERAGE('Table'[value]),ALLSELECTED('Table'[CC])),
        CALCULATE ( SUM ('Table'[value] ) )
    )

Vlianlmsft_0-1624341586024.png

 

View solution in original post

littlemojopuppy
Super User
Super User

Try something along the lines of IF(SELECTEDVALUE(CostCenter) = 803, [do something], [do something else])

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.