Forum Discussion

fernandoC's avatar
fernandoC
Icon for Helper V rankHelper V
6 years ago
Solved

Funnel Formula

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 ...
Need Help
  • fernandoC's avatar
    fernandoC
    6 years ago

    Hi @mwegener @v-she-msft ,

    I found the solution to my problem.

    Just created a new measure with

    IF(ISBLANK('Region 2020 - Candidates'[Total Status]),BLANK(),[- Funnel])
    Thanks again for your help!.
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi fernandoC ,

 

can you provide an example file?

 

  • fernandoC's avatar
    fernandoC
    Icon for Helper V rankHelper V
    6 years ago

    Hi @mwegener @v-she-msft ,

    I found the solution to my problem.

    Just created a new measure with

    IF(ISBLANK('Region 2020 - Candidates'[Total Status]),BLANK(),[- Funnel])
    Thanks again for your help!.