cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MunroA7 Regular Visitor
Regular Visitor

Headline Percentage on Card or KPI based on filter

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.

 

card percentage.PNG

 

 

 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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Headline Percentage on Card or KPI based on filter

Hi @MunroA7,

 

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Headline Percentage on Card or KPI based on filter

Hi @MunroA7,

 

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MunroA7 Regular Visitor
Regular Visitor

Re: Headline Percentage on Card or KPI based on filter

Works perfectly!

 

Thank you.