The high-level steps involve, creating two variables with the appropriate filters using “if else” (similar to click here). Then, perform the calculations based on this video.
In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and post it here. (Details on using Arena can be found here - QuickSight Arena
Numerator = Total Count of distinct Issue ID where Issue type in ‘Kiwi’,‘Mango’,‘Banana’
And Discovery Channel not in ‘ACT’ and ‘CBB
Denominator = Total count if distinct Issue ID
Calculation = Numerator/Denominator
When i create variables using ‘if else’, it doesnt allow me to even add to it my numerator but i tried using IN function and it did work. Now the challenge i have is to divide the numerator with the denominator. It says " mismatched aggregation". Please help.