Is there a way to apply filter context when using Divide?
I would like a Dax measure to Calculate the Hit Rate%: Sales Transaction / Traffic without Store type: SIS.
The expected result is Hit Rate = 4.2%
Thanks in advance for the assistance !
Data for reference:
data.csv (671 Bytes)