Forum Discussion

mahitham's avatar
mahitham
Helper I
7 years ago
Solved

Measure syntax help

Hi,   Can any one please help me to write the expression like   Sum(visits) where Media Type = "PAID MEDIA"   In Media Type i have PAID MEDIA and SOCIAL MEDIA. In the above expression i have to...
Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    mahitham

     

    Try like this for your filter

     


    FILTER (
       ALL ( 'Digital Marketing'[Media Type] ),
      'Digital Marketing'[Media Type] = "PAID MEDIA"
     )

  • popov's avatar
    popov
    7 years ago

    Hello, mahitham

    Correct formula below

    Paid Media Visits =
    CALCULATE (
        [Total Visits],
        FILTER ( 'Digital Marketing', 'Digital Marketing'[Media Type] = "PAID MEDIA" )
    )

popov's avatar
popov
Resolver III
7 years ago

Hello, mahitham

Correct formula below

Paid Media Visits =
CALCULATE (
    [Total Visits],
    FILTER ( 'Digital Marketing', 'Digital Marketing'[Media Type] = "PAID MEDIA" )
)