Forum Discussion
nezzzz
2 years agoFrequent Visitor
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 ...
- 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])ReturnIF(ISBLANK(_Verdict),"No Value",DISTINCTCOUNT('TestCasesHistory'[Verdict]))then create a visual with 100% Stacked Bar.After that, you can plot those value into the visualHope this will help you.
Thank you.