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
Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!