Hi All,
Struggling on one of my dashboard. I'm trying to display the Qualification Rate of all our leads, excluding Facebook but also create a button which allows us to look at Facebook data when need be
This is what is looks like without any slicers/filters being activated. Every enquiry source is included in these values
This is what it looks like when I click on the Facebook slicer. This part works fine, it's just the previous image that I'm having problems with. I don't want Facebook included in the main data but I still access to look at it.
Any help would be welcomed.
Thanks,
Mike
Hi @michael_knight ,
We can try to use the following measure to meet your requirement.
Divide =
IF (
SELECTEDVALUE ( 'Lead'[Category] ) = "Facebook",
DIVIDE (
COUNTX (
FILTER (
'Lead',
( 'Lead'[new_disqualifiedreason] = 279640000
|| 'Lead'[new_disqualifiedreason] = 279640004
|| 'Lead'[new_disqualifiedreason] = 279640002 )
&& 'Lead'[Statecode] = 2
&& [Category] = "FaceBook"
),
[Statecode]
),
COUNTROWS ( FILTER ( 'Lead', [Category] = "FaceBook" ) )
),
DIVIDE (
COUNTX (
FILTER (
'Lead',
( 'Lead'[new_disqualifiedreason] = 279640000
|| 'Lead'[new_disqualifiedreason] = 279640004
|| 'Lead'[new_disqualifiedreason] = 279640002 )
&& 'Lead'[Statecode] = 2
&& [Category] <> "FaceBook"
),
[Statecode]
),
COUNTROWS ( FILTER ( 'Lead', [Category] <> "FaceBook" ) )
)
)
BTW, pbix as attached.
Best regards,
Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more
Helpful resources
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
