Forum Discussion

wilfredtsk's avatar
wilfredtsk
Icon for Helper I rankHelper I
8 years ago
Solved

Measure: Displaying "cluster data"

Hi PowerBI pros, need help and advice pls. Am trying to display chart with clustering of data for performance appraisal, i.e.   Number of staff which are B performance and above Number of staff ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    wilfredtsk,

    Please replace  the Grade table to your table name in the following DAX.

    B and Higher = CALCULATE( COUNT('Grade Table'[STAFF NAME]), 'Grade Table'[GRADING] in {"A" , "B+", "B" })

    B- and Lower= CALCULATE( COUNT('Grade Table'[STAFF NAME]), 'Grade Table'[GRADING] in {"B-" , "C+", "C" })

    And you can create a chart as shown in the following screenshot.


    Regards,
    Lydia

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi wilfredtsk,

 

Try to use this measures below:

 

B and Higher = CALCULATE( COUNT(Grades[STAFF NAME]), Grades[GRADING] in {"A" , "B+", "B" })

B- and lower = CALCULATE( COUNT(Grades[STAFF NAME]), Grades[GRADING] in {"B-" , "C+", "C" })

Regards,

MFelix

  • wilfredtsk's avatar
    wilfredtsk
    Icon for Helper I rankHelper I
    8 years ago

    Hi MFelix,

     

    Thank you for the speedy reply. It don't seem to work as the grades are highlighted in "red"

    Also, once I have the measure, how can I display it as a chart?

     

    Sorry for the trouble.

     

    wilfredtsk

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      wilfredtsk,

      Please replace  the Grade table to your table name in the following DAX.

      B and Higher = CALCULATE( COUNT('Grade Table'[STAFF NAME]), 'Grade Table'[GRADING] in {"A" , "B+", "B" })

      B- and Lower= CALCULATE( COUNT('Grade Table'[STAFF NAME]), 'Grade Table'[GRADING] in {"B-" , "C+", "C" })

      And you can create a chart as shown in the following screenshot.


      Regards,
      Lydia