Help req'd with simple DAX measure

[tbablue]

Hi forum,

Long time user of Excel board - first time posting about DAX

I need a DAX measure that will sum the values of 'Reporting_Data'[Hours] for all the corresponding values of 'Reporting_Data'[Period] that equal another measure that I've created called 'Largest Period Before Today (Unaffected by Slicers)'.

I appreciate that this may be straightforward - but I'm a noob at DAX.

Any help gratefully rec'd.

 

[JEC]

Can't load PBI to test but it would be something like this, depending on how you other measure looks like.

=calculate(sum(reportTable[HoursColumn]),[PeriodColumn] = yourOtherMeasure)

 

[tbablue]

Thanks for your attention.

Your measure seems simpler than mine was.

The DAX I've written based on your advice ...

Current Weekly Hours = CALCULATE(SUM(Reporting_Data[Hours]),Reporting_Data[Period] = [Largest Period Before Today (Unaffected by Slicers)])

...yields me an error message

"A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed."

Any ideas?

I suspect the issue is the measure, [Largest Period Before Today (Unaffected by Slicers)]) !?

 

[JEC]

Yes, that should be a single value. What is the output of that measure? Could you post the measure?

 

[tbablue]

Thanks for your attention.

Your measure seems simpler than mine was.

The DAX I've written based on your advice ...

Current Weekly Hours = CALCULATE(SUM(Reporting_Data[Hours]),Reporting_Data[Period] = [Largest Period Before Today (Unaffected by Slicers)])

...yields me an error message

"A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed."

Any ideas?

I suspect the issue is the measure, [Largest Period Before Today (Unaffected by Slicers)]) !?

This was my measure ... it ran ... but did

Yes, that should be a single value. What is the output of that measure? Could you post the measure?

Yes, that should be a single value. What is the output of that measure? Could you post the measure?

This is the measure ...

Largest Period Before Today (Unaffected by Slicers) =
VAR AllPeriods = ALL('Reporting_Data'[Period])
VAR Today = TODAY()
RETURN
CALCULATE(
MAX('Reporting_Data'[Period]),
FILTER(
'Reporting_Data',
'Reporting_Data'[Period] <= Today
&& CONTAINS(AllPeriods, 'Reporting_Data'[Period], 'Reporting_Data'[Period])
)
)

 

[JEC]

What if you write your largest period measure like this;

=CALCULATE(
   MAX('Reporting_Data'[Period]),
      ALL('Reporting_Data'[Period]),
     'Reporting_Data'[Period] <= today()
 )

 

[tbablue]

Your DAX is definitely simpler (which I obviously prefer) but it still yields the same error message in my other piece of DAX.

I think perhaps I need to try something different.

 

[JEC]

Really hard to tell without the file or data... maybe you can post some sample data and desired outputs