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.

nezzzz's avatar
nezzzz
Frequent Visitor
2 years ago

Hey Irwan,

 

Thanks a lot for your reply!

 

I don't want to have the Result_Date in the chart (so the chart is going to look like your first screenshot), but in that chart, I would also like to have the % of No results. And yes, the % will be modified once 'No results' will be added. But as mentioned, I don't know how to count the number of days where there are no entries. 

Irwan's avatar
Irwan
Icon for Super User rankSuper User
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.