Forum Discussion
DAX Column/Measure
You can also optimize the measure like this:
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RhmjJ_yFo7pNmkZA-?e=koDNaG
Thanks Ahmed for the logic.
i checked the logic but your logic is not working for couple of scenarois like if there are continiuos 4 Wins (it is counting as 2)
ex. for below data, it is showing count as 2 which is wrong. it should be 1
also it shows 4 when there are 6 continious W .instead it should show 2
| 1 | Batman | L |
| 2 | Batman | W |
| 3 | Batman | W |
| 4 | Batman | L |
| 5 | Batman | W |
| 6 | Batman | W |
| 7 | Batman | W |
| 8 | Batman | W |
try writing like this:
https://1drv.ms/u/s!AiUZ0Ws7G26RhnuWCUbFELKVmBc-?e=yTis0rThanks much Ahmed for this refined logic.
this is not working for below scenario -
if some has won 6/9 times continiously (WWWWWW), it still shows 1. instead it should show 2/3.
it would be great if you can accomodate this scenario in your formula. appreciate your help on this.