topic Re: Unable to apply measure to CALCULATE statement in DAX Commands and Tips

Unable to apply measure to CALCULATE statement

Tini-Bee — Mon, 10 Feb 2025 07:53:23 GMT

I want to utilise the CALCULATE MAX and ALL('Date') as follows:

Sum Range Space =

varTest = CALCULATE(MAX([SumRangeSpace1], ALL('Date')))
VAR RangeSpaceCount = CALCULATE(COUNT(' Build_Capacity'[RangeSpace]

VAR TotalCount = CALCULATE(DISTINCTCOUNT('Build_Usage'[ID]), ALL('Date'))

VAR BLANKK = BLANK()

RETURN

IF (

(

ISFILTERED ( 'Hs'[House Name] )

&& RangeSpaceCount = TotalCount

[SumRangeSpace1],

BLANK()

)

The underlying measure [SumRangeSpace1] is

SumRangeSpace1 = CALCULATE (

SUM( 'Build_Capacity'[RangeSpace] ),

TREATAS (

VALUES ( 'Build_Usage'[ID] ),

'Build_Capacity'[ID]

)

Re: Unable to apply measure to CALCULATE statement

bhanu_gautam — Mon, 10 Feb 2025 08:10:24 GMT

Tini-Bee Try using

DAX
SumRangeSpace =
VAR varTest = CALCULATE(MAX([SumRangeSpace1]), ALL('Date'))
VAR RangeSpaceCount = CALCULATE(COUNT('Build_Capacity'[RangeSpace]))
VAR TotalCount = CALCULATE(DISTINCTCOUNT('Build_Usage'[ID]), ALL('Date'))
VAR BLANKK = BLANK()

RETURN
IF (
ISFILTERED('Hs'[House Name]) && RangeSpaceCount = TotalCount,
[SumRangeSpace1],
BLANKK
)

Re: Unable to apply measure to CALCULATE statement

AntrikshSharma — Mon, 10 Feb 2025 09:01:50 GMT

Tini-Bee What is the issue here?

Re: Unable to apply measure to CALCULATE statement

Tini-Bee — Mon, 10 Feb 2025 10:01:10 GMT

bhanu_gautam
VAR varTest = CALCULATE(MAX([SumRangeSpace1]), ALL('Date')) doesn't work

error returned is 'The expression refers to multiple columns'

SumRangeSpace =
VAR varTest = CALCULATE(MAX([SumRangeSpace1]), ALL('Date'))
VAR RangeSpaceCount = CALCULATE(COUNT('Build_Capacity'[RangeSpace]))
VAR TotalCount = CALCULATE(DISTINCTCOUNT('Build_Usage'[ID]), ALL('Date'))
VAR BLANKK = BLANK()

RETURN
IF (
ISFILTERED('Hs'[House Name]) && RangeSpaceCount = TotalCount,
varTest,
BLANKK
)

Re: Unable to apply measure to CALCULATE statement

Tini-Bee — Fri, 14 Feb 2025 12:01:31 GMT

rectified this issue using
CALCULATE([SumRangeSpace1], ALL('Date'))