Forum Discussion

BenCha's avatar
BenCha
Regular Visitor
1 year ago
Solved

Top 5 non conformities with text data

Hey guys, I'm starting with Power Bi and I'm learning and enjoying it a lot, but I don't know all the possibilities of this tool. For work purpose I need to do a report about the non conformities i...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi BenCha ,

     

    (1) Select the 34 problem columns in Power query and click on Unpivot Columns.->Then add a conditional column.->Click on "close and apply"

     

    (2) We can create measures.

    Count_Non = COUNTROWS(FILTER('Table', 'Table'[Custom]="Non Conforme"))
    Rank = RANKX(SUMMARIZE(ALLSELECTED('Table'),[N°],"count",[Count_Non]),[Count_Non],[Count_Non],DESC,Dense)
    Flag = IF([Rank]<=5,1,0)

    (3) Place [Flag=1] on the visual object.

    If I have misunderstood you, please clarify in a follow up reply with an example of your expected output.

     

    Best Regards,

    Neeko Tang

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

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi BenCha ,

 

(1) Select the 34 problem columns in Power query and click on Unpivot Columns.->Then add a conditional column.->Click on "close and apply"

 

(2) We can create measures.

Count_Non = COUNTROWS(FILTER('Table', 'Table'[Custom]="Non Conforme"))
Rank = RANKX(SUMMARIZE(ALLSELECTED('Table'),[N°],"count",[Count_Non]),[Count_Non],[Count_Non],DESC,Dense)
Flag = IF([Rank]<=5,1,0)

(3) Place [Flag=1] on the visual object.

If I have misunderstood you, please clarify in a follow up reply with an example of your expected output.

 

Best Regards,

Neeko Tang

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