Not able to use HASONEVALUE or HASONEFILTER

[ROG]

Hi all, the first measure below is the Churn Rate YTD Diff, but as I want the total on the table to show the total (sum) of the rows, I tried to use the functions HASONEVALUE or HASONEFILTER, but I'm struggling to get this correct.

Net Churn - 30D% YTD Diff = [Net Churn - 30D% YTD] - [Net Churn - 30D% LYTD]

Net Churn - 30D% YTD Diff = IF(HASONEFILTER('Tenure Band'[Tenure Band], HASONEFILTER('Tenure Band'[Tenure FlagB], HASONEFILTER('Tenure Band'[Tenure Flag],HASONEFILTER('Customer Category'[Customer Category Name],[Net Churn - 30D% YTD Var])))))

I need to slice and dice by 4 different fields. (Two different tables - Tenure and Customer Category)

Instead of - 0.22, it should show 1.88

How can I get this right?

Thanks! 

[amitchandak]

@ROG , Not very clear. But isinscope can be a better option

isinscope

https://youtu.be/cN8AO3_vmlY?t=32880

Isfiltered/hasonevalue

https://www.youtube.com/watch?v=cN8AO3_vmlY&t=10110s

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.