Measure syntax help

[mahitham]

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 show only PAID MEDIA visits.

I have tried like below but getting error. Please help me on this.

Thanks in advance

[LivioLanzo · Accepted solution]

@mahitham

Try like this for your filter

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

[popov · Accepted solution]

Hello, @mahitham

Correct formula below

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

[LivioLanzo · Accepted solution]

@mahitham

Try like this for your filter

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