Forum Discussion

Veronika3's avatar
Veronika3
Regular Visitor
10 months ago
Solved

Duplicate total despite the filter used

Hello, I need help with this measure.  I have a measure that works correctly only if I do not filter by country. This is how it looks when it’s correct: Meta test = IF (     SELECTEDVALUE ( fil...
  • tamerj1's avatar
    tamerj1
    10 months ago

    Hi Veronika3 

    Please try

    Meta test =
IF (
    SELECTEDVALUE ( filterHide[Text] ) <> "Hide",
    CALCULATE (
        SUM ( factMetaCampaign[SpendEur] ),
        KEEPFILTERS (
            TREATAS (
                VALUES ( relCampaignSUParticipation[generatedID] ),
                factMetaCampaign[GeneratedID_PPID]
            )
        ),
        KEEPFILTERS (
            TREATAS (
                VALUES ( relCampaignSUParticipation[Partner] ),
                factMetaCampaign[PartnerSUParticipation]
            )
        )
    )
)
Veronika3's avatar
Veronika3
Regular Visitor
10 months ago
Unfortunately, even after removing the relevant syntax, the correct value still did not appear when filtering by country.
Meta test= IF (
    SELECTEDVALUE ( filterHide[Text] ) = "Hide",
    BLANK (),
    CALCULATE (
        SUM ( factMetaCampaign[SpendEur] ),
        TREATAS ( VALUES ( relCampaignSUParticipation[generatedID] ),       factMetaCampaign[GeneratedID_PPID] ),
        TREATAS ( VALUES ( relCampaignSUParticipation[Partner] ),           factMetaCampaign[PartnerSUParticipation] )
    ))
  • anilelmastasi's avatar
    anilelmastasi
    Icon for Super User rankSuper User
    10 months ago

    Do you have country dimenison?