Forum Discussion

nezzzz's avatar
nezzzz
Frequent Visitor
2 years ago
Solved

Count rows that don't exist.

Hello, first ever post here, hope I'm posting this in the right forum. I am having a difficult time with the creation of a measure for a specific scenario. I have the below two tables, the first one ...
  • Irwan's avatar
    Irwan
    2 years ago

    Hello nezzzz 

     

    if you dont want Result_Date in chart, I assumed it might be TestCaseID as you want to see those verdict number.

     

     

    Both TC3 and TC4 have no result so it is empty (I believe you can not show it as 'No Result" value in visualization so "No Result" means empty value).

     

    for this, create a measure with following DAX:

    Verdict Calculation =
    var _Verdict = SELECTEDVALUE('TestCasesHistory'[Verdict])
    Return
    IF(
        ISBLANK(_Verdict),
        "No Value",
        DISTINCTCOUNT('TestCasesHistory'[Verdict])
    )
     
    then create a visual with 100% Stacked Bar.
    After that, you can plot those value into the visual

     

    Hope this will help you.

    Thank you.

Irwan's avatar
Irwan
Icon for Super User rankSuper User
2 years ago

Hello nezzzz 

 

trying to understand what your goal.

You said 1-May to 5-May is 50% Pass and 50% Fail and you said you want to show "No-Result" on 2-May and 4-May.

Do you want to find total value or distribute the value based on date?

 

When you didnt put Result_Date value in your stacked visual, then yes you got 50%-50% which is calculating total value.

 

But as soon as you put Result_Date value, it will separate those value based on date. Value on 1-May is 2 because there are two values on 1-May (TC1 Fail and TC2 Fail).

is this what you need by showing as "No-Result"? Value on 2-May and 4-May are blank.

 

Hope this will help you.

Thank you.