Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Try like this for your filter
FILTER (
ALL ( 'Digital Marketing'[Media Type] ),
'Digital Marketing'[Media Type] = "PAID MEDIA"
)
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Hello, @mahitham
Correct formula below
Paid Media Visits =
CALCULATE (
[Total Visits],
FILTER ( 'Digital Marketing', 'Digital Marketing'[Media Type] = "PAID MEDIA" )
)
Hello, @mahitham
Correct formula below
Paid Media Visits =
CALCULATE (
[Total Visits],
FILTER ( 'Digital Marketing', 'Digital Marketing'[Media Type] = "PAID MEDIA" )
)
Try like this for your filter
FILTER (
ALL ( 'Digital Marketing'[Media Type] ),
'Digital Marketing'[Media Type] = "PAID MEDIA"
)
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |