Forum Discussion

king5six1's avatar
king5six1
Regular Visitor
7 years ago
Solved

Help with COUNTIFS Formula in DAX

Hello. Newbie here. I have a problem I have been trying to solve to no avail. I have a COUNTIF formual in excel that is returning a percentage based on several columns. I cannot get this working in D...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi king5six1,

    Based on my test, you could use the Count function to calculate the percentage:

    Sample data:

    Create a measure:

    Measure = CALCULATE(COUNT(Table1[N]),FILTER('Table1','Table1'[N]=1))/CALCULATE(COUNT(Table1[Q]),FILTER('Table1','Table1'[Q]=1))

    Result:

    You could also download the pbix file to have a view.

     

    Regards,

    Daniel He

king5six1's avatar
king5six1
Regular Visitor
7 years ago

Im not sure I can post the whole thing. There is some confidential info in there. If this helps, the specific column names are. I am trying to rebuild an excel report from scratch using the source salesforce reports in Power BI.

 

Negative Score

Count

Representative: Role: Name (groups) - This is the teams. I had to create a group for them as several roles make up a Team.

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi king5six1,

Based on my test, you could use the Count function to calculate the percentage:

Sample data:

Create a measure:

Measure = CALCULATE(COUNT(Table1[N]),FILTER('Table1','Table1'[N]=1))/CALCULATE(COUNT(Table1[Q]),FILTER('Table1','Table1'[Q]=1))

Result:

You could also download the pbix file to have a view.

 

Regards,

Daniel He