Headline Percentage on Card or KPI based on filter

[Anonymous]

Hi,

I expect this is simple but I want to display a series of 'headline' ratios or pecentages on my report using cards or KPI visuals.

I'm using these type of measures in tables:

Conversion % = DIVIDE([No. of Leads],CALCULATE([No. of Leads],ALLSELECTED('Leads'[Status])))

Exhibition % = DIVIDE([No. of Leads],CALCULATE([No. of Leads],ALLSELECTED('Leads'[Exh/Non-Exb])))

Which is great and works perfectly but when I want to use one on a card that gives a percentrage of just status of 'qualified' or 'Exhibitions' I get 100% displayed.

 I feel like there is perhaps another measure I need to write in DAX to get the result I want.  Can anyone help please?

Many thanks.

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Please try these two formulas:

Conversion % =
DIVIDE (
    CALCULATE ( [No. of Leads], ALLEXCEPT ( Leads, Leads[Status] ) ),
    CALCULATE ( [No. of Leads], ALL ( Leads ) )
)

Exhibition % =
DIVIDE (
    CALCULATE ( [No. of Leads], ALLEXCEPT ( Leads, Leads[Exh/Non-Exb] ) ),
    CALCULATE ( [No. of Leads], ALL ( 'Leads' ) )
)

If this doesn't work, please share some sample data and the formula of measure [No. of Leads] for further analysis.

Thanks,
Yuliana Gu

[Anonymous]

Works perfectly!

Thank you.