How to count the row count matching the selected data set, where the issue type match

[udani969]

Hi,

I have built a star schema as below. I have two flat files loaded as test_execution_summary and defect_report. Records in the test execution summary is filtered using the practice name and then again the project name. After that I am using a visual filter to filter in cycles related to the recent release, which I calculate through a measure.

Relationships between tables are as follows:

- defect_report[IssueKey] = test_execution_summary[ExecutionDefect]

- test_cycle_details[cycleID] = test_Execution_summary[CycleID]]

In the defect table there are two types of issues, bugs and defects. I need to calculate the bug count of each cycle, selected for the latest release. I tried to use below measure, but it is making the bug count value empty. 

Bugs Count 1 = CALCULATE(COUNTROWS(FILTER(defect_report, defect_report[Issue Type]="Bug")), RELATEDTABLE(test_execution_summary))

I have been trying different ways to get this to work, but i can't figure out the way. I am totally new to Power BI. Appreciate if someone can help me to figure out what i am doing wrong and how to fix this.

[Anonymous]

Hi, @udani969 

I am glad you were able to solve the problem, if you have additional needs, you can either ask here or reopen the post. I will feel free to help you about anything.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[udani969]

Bug Count 2 = 
  CALCULATE(
    COUNT('test_execution_summary'[ExecutionDefect]) + 0,
    'defect_report'[Issue Type] = "Bug"
  )

This measure worked. I had to add +0 at the end of COUNT method to get 0 when there aren't any values to sum.