Forum Discussion

Ben_G's avatar
Ben_G
Frequent Visitor
4 years ago

Counting multiple matches

Hi. New to this forum so hope my post is clear. I have a table of campaign formats: Format Digital HPP SPP Others I have a table of campaigns which can have 1 or more formats (NB...
Need Help
Icey's avatar
Icey
Community Support
4 years ago

Hi Ben_G ,

 

Can this work in your scenario?

Measure =
SUMX (
    VALUES ( FormatTable[Format] ),
    CALCULATE (
        COUNTROWS (
            FILTER (
                ( CampaignTable ),
                CONTAINSSTRING ( CampaignTable[Format], MAX ( FormatTable[Format] ) )
            )
        )
    )
)

 

 

 

Best Regards,

Icey

 

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