Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a measure Update Score ( Values : 1, 2,3 )
Update score is calculated by range comparison in if then else i.e
update score = [ if avg( min a + min b ) between 2 and 5 then 1 else so on ]
In KPI caluculation :
=count({<'$V_Update_score'={'3'}>}([Test ID])) to count test_ids where update_score = 3
This expression is not taking where clause in set analysis and returning just the total ids.
Please suggest.
Hi, sorry for my english,
Maybe this help you
=count({<[Test ID]={"=$(V_Update_score)=3"}>} [Test ID] )