Forum Discussion
Solved
Visual with Top N not working upon using one specific filter - shows same value for each
Hi, I have a visual which shows the top 5 reasons of why customers churn. The value of each reason's share is calculated like so Share of Tickets by Reason = DIVIDE (DISTINCTCOUNT(table[tic...
HI MFelix thanks for your answer, with a little help from your answer and some more PowerBI DAX researching (and blunt trying out) I managed to solve the issue by changing the DAX from
ALL((table[Reason])to
ALLEXCEPT(no_appointment_reasons, no_appointment_reasons[reporting_week])
As I want to calculate the percentage over all the tickets from that week, as it is displayed on a weekly level in the visual.
HI MFelix thanks for your answer, with a little help from your answer and some more PowerBI DAX researching (and blunt trying out) I managed to solve the issue by changing the DAX from
ALL((table[Reason])
to
ALLEXCEPT(no_appointment_reasons, no_appointment_reasons[reporting_week])
As I want to calculate the percentage over all the tickets from that week, as it is displayed on a weekly level in the visual.
As I want to calculate the percentage over all the tickets from that week, as it is displayed on a weekly level in the visual.