Forum Discussion
filtering row level data after slicer selection
If I understand correctly, you want the 'other' to total all non-selected key products, but only for agreements that do contain the selected product, for example if generator is selected, it will total all NON-generator items but only for agreements containing generators. If the result is 0, return Blank instead.
I think this will do it for you. I have also attached the Power BI file.
Total_All_Non-Selected_But_Agreement_Contains_Selected =
var selected_product = SELECTEDVALUE('product'[product])var table1 = CALCULATETABLE(agreements, ALL('product'[product]), 'product'[key_product] = 1)var table2 = SUMMARIZE(table1,[agreement_number],"@selected_sum", CALCULATE(COALESCE(SUM(agreements[agreement_value]), 0), 'product'[product] = selected_product),"@not_selected_sum", CALCULATE(COALESCE(SUM(agreements[agreement_value]), 0), 'product'[product] <> selected_product))
VAR RESULT =COALESCE(SUMX(table2, IF([@selected_sum] > 0, [@not_selected_sum], 0)), 0)RETURN IF(RESULT = 0, BLANK(), RESULT)///Mediocre Power BI Advice, but it's free///
If I understand correctly, you want the 'other' to total all non-selected key products, but only for agreements that do contain the selected product, for example if generator is selected, it will total all NON-generator items but only for agreements containing generators. If the result is 0, return Blank instead.
I think this will do it for you. I have also attached the Power BI file.
