Forum Discussion

Coriel-11's avatar
Coriel-11
Resolver II
2 years ago

DAX Help - replace an aggregated value

Hi everyone, I have a table ("Interactions") that looks like this: Date Team Interactions Source   15/03/2024 Training 328 Emails 06/04/2024 Training 456 Calls 31/05/2024 Membersh...
Need Help
ExcelMonke's avatar
ExcelMonke
Impactful Individual
2 years ago

Hello,

You can consider the following to see if this will get  you your intended result:

Measure = 
VAR _Interactions = 
IF (
    AND ( Interactions[Team] = "Training", Interactions[Source] = "Emails" ),
    TRUE (),
    FALSE ()
)

VAR _Date = 
IF (
    AND ( YEAR ( 'Calendar'[Date] ) = 2024, MONTH ( 'Calendar'[Date] ) = 5 ),
    TRUE (),
    FALSE ()
)

RETURN
IF ( AND ( _Interactions, _Date ), 4160, SUM ( Interactions[Interactions] ) )

 

  • Coriel-11's avatar
    Coriel-11
    Resolver II
    2 years ago

    Hi, thanks for you answer, unfortunately, though I still have to add the MAX() function around the fields (or else I get errors) and then that seems to lead me back to where I was before – same results at least. I'd been hoping there was a better alternative to MAX for text, or something like HASONEVALUE().
    I really appreciate the suggestion, though.
    Matt