can someone help me to filter the data without having a table relationship?
I can create a relationship and get the numbers right whereas I am doing basket analysis where I shouldn't relate to that table to arrive the number.
In the below table I am unable to get the right number on the tooltip. where it should be the combination of 29 counts. but I am getting the total number of Audit and Adv solution. (Rows from SSL table and Columns from Comparison SSL)
Let me know if there any alternatives?
@RanjanThammaiah , Yes you have force a filter in a Measure
calculate([Measure], filter('S&P','S&P'[SSL] in selectedvalues('SSL'[SSL])))
calculate([Measure], filter('S&P','S&P'[SSL] in values('SSL'[SSL])))
I have not used complete table names. Please use correct table and column name