Percentage of dashboard Card / Silcer filter results

[dcg38524]

Hello everyone,

I need your help & advice - We have created a dashboard which does include a Slicer & Cards.  We are looking to add another Card which will Illustrate the percentage of Outage Count when a single Year is selected within Slicer "Year"(see snap shot below)

I am not suprise the DAX script created below does not work.

Any help would be greatly appreciated.

Percentage Count = 
    SUM('MajorIncidentTickets_2022-23'[number]) /CALCULATE(SUM('MajorIncidentTickets_2022-23'[number]), FILTER(ALL('MajorIncidentTickets_2022-23'),'MajorIncidentTickets_2022-23'[problem_id]=SELECTEDVALUE('MajorIncidentTickets_2022-23[problem_id]))

[v-rzhou-msft · Accepted solution]

Hi @dcg38524 ,

I think you just need ALL() function in second part code, remove the SELECTEDVALUE() part, or your measure will return 100%.

Percentage Count =
VAR _SelectPeriod =
    CALCULATE ( SUM ( 'MajorIncidentTickets_2022-23'[number] ) )
VAR _Total =
    CALCULATE (
        SUM ( 'MajorIncidentTickets_2022-23'[number] ),
        ALL ( 'MajorIncidentTickets_2022-23' )
    )
RETURN
    DIVIDE ( _SelectPeriod, _Total )

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dcg38524]

Rico,

This reall helps a great deal - I cannot thank you enough for taking the time to post a great solution.

Regards,

Don