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!
I've built a formula to show a funnel including all candidates from each stage so that if they move from one stage to the other it replicates it's value instead of having 6-7 candidates with each stage by using a stage numeric order. The formula I'm using is:
Solved! Go to Solution.
Hi @mwegener @v-she-msft ,
I found the solution to my problem.
Just created a new measure with
Hi @fernandoC
Kindly check below whether helps:
- Funnel =
SUMX (
FILTER (
ALL ( 'Region 2020 - Candidates'[Status]),
'Region 2020 - Candidates'[Status Order] >= MAX ( 'Region 2020 - Candidates'[Status Order] )
),[- Applications]
)
If not, you might consider providing your dummy pbix that would be helpful for us to investigate it further.
You can upload it to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.
Hi @mwegener @v-she-msft ,
I found the solution to my problem.
Just created a new measure with
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 |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |