cancel
Showing results for
Did you mean:
JoleneB New Member

## Calculate Measure unless other column is X value

Hi guys,

I currently have the below Measure. This works perfectly for all except for Location Code of 'SP'.

Does anyone know how I would adjust the measure so that if Location Code = SP then value = 450000. The intention is to use this in a Matrix visualisation, so Total would need to include this static value.

Currently Projected Sales =
SUMX(
SUMMARIZE(
'Current Month Sales',
'Location'[Country Code],
'Location'[Location Type],
'Location'[Location Code]
)
,
"Projected Sales", ((([TOTAL W/O] * 200) + [Total Sales]) / [Work Days So Far]) * [Work Days]
),[Projected Sales])
1 ACCEPTED SOLUTION

Accepted Solutions Community Support Team

## Re: Calculate Measure unless other column is X value

You may modify the calculate column using dax below:

```Currently Projected Sales =
SUMX (
SUMMARIZE (
'Current Month Sales',
'Location'[Country Code],
'Location'[Location Type],
'Location'[Location Code]
),
"Projected Sales", ( ( ( [TOTAL W/O] * 200 ) + [Total Sales] ) / [Work Days So Far] ) * [Work Days]
),
IF ( 'Location'[Country Code] = "SP", 450000, [Projected Sales] )
)
```

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Community Support Team

## Re: Calculate Measure unless other column is X value

You may modify the calculate column using dax below:

```Currently Projected Sales =
SUMX (
SUMMARIZE (
'Current Month Sales',
'Location'[Country Code],
'Location'[Location Type],
'Location'[Location Code]
),
"Projected Sales", ( ( ( [TOTAL W/O] * 200 ) + [Total Sales] ) / [Work Days So Far] ) * [Work Days]
),
IF ( 'Location'[Country Code] = "SP", 450000, [Projected Sales] )
)
```

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements   