Forum Discussion

PaulMac's avatar
PaulMac
Helper IV
7 years ago
Solved

DAX DISTINCTCOUNT Help needed

Hello all

I need some assitance with creating a DAX measure to do the following.

count the number of people who have scored more than or equal to 4, more than or equal to 3 or less than 3.

As can be seen in the SampleData file, I have filtered the data to only show those who have an average score below 3.

10 names appear in the filtered table, but the only DAX I have been able to produce give me a count of 13!!??

I need to produce a DAX measure that will correctly do a distinct count of the Names to give a numerical value of those whose Average QA score is above or below a certain threshold.

 

I need to learn how to accomplish this in Power BI using a DAX measure.

Click Here to see attached SampleData file to illustrate what I am trying to accomplish.

Thanks

PaulMc

Need Help
Tutorial Requests
  • RobbeVL's avatar
    RobbeVL
    7 years ago

    Hi,

     

    Here I calcuated who has an average score <3

    Measure = 
COUNTX(
    FILTER(
    SUMMARIZE('Table'; 'Table'[Name]; "av"; AVERAGE('Table'[Score]));
    [av] <3); 
DISTINCTCOUNT('Table'[Name]))

    There might be an easier way, but this will work :)

    Robbe

6 Replies

  • RobbeVL's avatar
    RobbeVL
    Impactful Individual
    7 years ago

    Hi,

     

    Here I calcuated who has an average score <3

    Measure = 
COUNTX(
    FILTER(
    SUMMARIZE('Table'; 'Table'[Name]; "av"; AVERAGE('Table'[Score]));
    [av] <3); 
DISTINCTCOUNT('Table'[Name]))

    There might be an easier way, but this will work :)

    Robbe

    • PaulMac's avatar
      PaulMac
      Helper IV
      7 years ago

      RobbeVL  You sir, are a wizard!!

      This is the second time this week you have helped me out!! I owe a coffee!! :smileywink:

      In all seriousness. do you have any online learning resources for DAX as I obviously need some further training in this field.

      Many thanks again.

      PaulMc

      • RobbeVL's avatar
        RobbeVL
        Impactful Individual
        7 years ago

        I'm sure you'll find alot on youtube.
        Udemy also has a few cheap trainings that might be of use. But make sure you do a PowerBI DAX training, PowerBI Doesnt support all DAX Functions.