Forum Discussion

janinw's avatar
janinw
Helper I
4 years ago
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...
Need Help
  • janinw's avatar
    janinw
    4 years ago

    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.
MFelix's avatar
MFelix
Super User
4 years ago

Hi janinw ,

 

You are making the ranking using the ALL statement, further more you do it based on a column that is the column Reason that way the calculation will only be correct when you have all the values in your table select so when you start to make filters based on other columns the table/column/row context changes and your result always returns 1.

 

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.