How to calculate percentage covered vs not covered

[sujaisparks]

Please help me with this scenario at hand

I have a factless fact table imported into a Power BI Desktop model that contains the product modules with Testcase Groups and Testcases as shown in the example below:

Module	TestCaseGroup	TestCaseID
A	G1	101
A	G1	102
A	G2	101
A	G2	102
A	G2	103
A	G2	104
A	G3	102
A	G3	105
B	G4	201
B	G4	203
B	G5	201
B	G5	202
B	G5	203

What I need to calculate and show in Power BI Desktop is two things:

1. When I select a Module (in slicer) and a Testcase Group (in slicer), how can I calculate the count or percentage of Testcases not covered by the Testcase Group for the selected module.  For example, if I select module A in the above table, there are total 5 distinct testcases. Within that module, if I select Testcase Group G1, the count of testcases covered is 2 and count of test cases not covered is 3. Similarly if I select G2, it is 4 vs 1.
2.  Also if possible, how to show the list of distinct testcaseids that are not covered by the selected Testcase Group for the selected module

Please kindly help.

[Zubair_Muhammad · Accepted solution]

HI @sujaisparks

Try these MEASURES

Test_Cases_Covered =
DISTINCTCOUNT ( TableName[TestCaseID] )

Test_Cases_Not_Covered =
CALCULATE (
    DISTINCTCOUNT ( TableName[TestCaseID] ),
    ALL ( TableName[TestCaseGroup] )
)
    - [Test_Cases_Covered]

[Zubair_Muhammad · Accepted solution]

@sujaisparks

To get the Names of IDs not covered, you can use this MEASURE

IDs not covered =
CONCATENATEX (
    EXCEPT (
        CALCULATETABLE (
            VALUES ( TableName[TestCaseID] ),
            ALL ( TableName[TestCaseGroup] )
        ),
        VALUES ( TableName[TestCaseID] )
    ),
    [TestCaseID],
    ", "
)

[Zubair_Muhammad · Accepted solution]

HI @sujaisparks

Try these MEASURES

Test_Cases_Covered =
DISTINCTCOUNT ( TableName[TestCaseID] )

Test_Cases_Not_Covered =
CALCULATE (
    DISTINCTCOUNT ( TableName[TestCaseID] ),
    ALL ( TableName[TestCaseGroup] )
)
    - [Test_Cases_Covered]

[sujaisparks]

Tons of thanks to you sir for the help!!

What changes do I have to do the measure (Test_cases_not_covered) if need to put the TestcaseGroup Dimension attribute (TestcaseGroupDescription) as a slicer. This is a snapshot of the relationship with the factless fact table.

Here is the copy of the poc i'm working on My POC

[sujaisparks]

Tons of thanks to you sir for the help!!

What changes do I have to do the measure (Test_cases_not_covered) if need to put the TestcaseGroup Dimension attribute (TestcaseGroupDescription) as a slicer. This is a snapshot of the relationship with the factless fact table.

Here is the copy of the poc i'm working on My POC

[Zubair_Muhammad · Accepted solution]

@sujaisparks

To get the Names of IDs not covered, you can use this MEASURE

IDs not covered =
CONCATENATEX (
    EXCEPT (
        CALCULATETABLE (
            VALUES ( TableName[TestCaseID] ),
            ALL ( TableName[TestCaseGroup] )
        ),
        VALUES ( TableName[TestCaseID] )
    ),
    [TestCaseID],
    ", "
)

[Zubair_Muhammad · Accepted solution]

@sujaisparks

See the file attached here as well

(With your data)