Forum Discussion

Phil-osophy's avatar
Phil-osophy
Icon for Helper I rankHelper I
7 years ago
Solved

Count Across Multiple Columns

Hi everyone, I'm new to Power BI and having some difficulty doing some analysis:   I want to be able to create a filter of the managers name, that when i select a manager, their top three error co...
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

Would you be OK with a 3 column layout of your final output - Name, Type of error and error count?

  • Phil-osophy's avatar
    Phil-osophy
    Icon for Helper I rankHelper I
    7 years ago

    Hey Ashish_Mathur !

    that could work, but would that mean that the 2nd and 3rd most frequent errors would be on their own rows? ideally all three would be listed in the same row to be more visually appealing

     

    thanks

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      7 years ago

      Hi,

      Yes, they would be on their own rows.  Would you be OK with that?