Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
BaronSdG
Resolver II
Resolver II

Cumulative funnel chart not working

Hi all,

I need to create a cumulative funnel of candidates throughout the status new applicant, candidates screen etc... (e.g. candidates in new applicant must also count candidates in later steps such as candidate screen, Hr interviews and everything that is in front of them).

 

BaronSdG_0-1682330668261.png

 

 
The data model below is the one below and is working for all other measures and forumals I have built. I need to count the number of applicant names in table 1. In table 4 I have the order of the stages
BaronSdG_1-1682330908294.pngBaronSdG_0-1682348945888.png

 

 

 

The formula I applied is this one, and I tried also to use coutrows instead of counta but the results is the same

Funnel =
CALCULATE (
    COUNTA(LevOpportunityApp_applications[Applicant name]),
    FILTER (
    ALL ( 'LeverStages_order/type'[Stage order]),
    'LeverStages_order/type'[Stage order] <= MAX( 'LeverStages_order/type'[Stage order] )
)
)
 

The issue is almost the same as this topic https://community.powerbi.com/t5/Desktop/Cummulative-Measure-for-Funnel/m-p/203025

 

 

Can you help me?

 

Thanks

1 REPLY 1
BaronSdG
Resolver II
Resolver II

I managed to fix it partially 

1. The all was poiting to a column instead of a table only

2. The sign of the maximum was inverted

 

Funnel2 =

CALCULATE (
    COUNTROWS(LevOpportunityApp_applications),
    FILTER (
            ALL ( 'LeverStages_order/type'), 'LeverStages_order/type'[Stage order] >= MAX( 'LeverStages_order/type'[Stage order] )
))
 
 
Now the result is as follows which is ALMOST what I want. Now I have 2 issues;
1. The issue with very long values e.g. the Status= Business review is due to the fact that such status didn't have any Candidates at all. Do you have any suggestions on how to not show these status if their value is zero? I can't hide such status as depending on the Job position, these statuses MIGHT be populated.
2. The values inside the graphs are OK (%)
 
Any idea how to fix these?

BaronSdG_0-1682609253804.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.