Forum Discussion

steveplatz's avatar
steveplatz
Frequent Visitor
6 years ago
Solved

ALLSELECTED Duplicating Table Output

Hi everyone,   I've got a problem that I can't seem to find a resolution to that I'm hoping you can help with. What I'm trying to do is calculate the MAX value for all selected rows and display tha...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi steveplatz 

    You could just adjust it as below:

    Step1:

    Adjust the formula as below:

    New MaxSelectedSales = CALCULATE(MAX(FactSales[Sales]),ALLSELECTED(FactSales),VALUES(DimMarket[MarketName]))
    Step2:
    change the cross filter direction from "Single" to "Both"

     

    Result:

    and here is sample pbix file, please try it.

     

    Regards,

    Lin

kentyler's avatar
kentyler
Solution Sage
6 years ago

You can change to ALLSELECTED

Max Sales per Market = VAR cur_Market = SELECTEDVALUE(Sales[MarketId])
VAR total_sales_per_market = CALCULATE(max(Sales[Sales]),ALLSELECTED(Sales),Sales[MarketId]=cur_Market) return total_sales_per_market
That seems to take both a store slicer and an iscurrent slicer into account
 
steveplatz's avatar
steveplatz
Frequent Visitor
6 years ago

This works when filtered to a specific market, but not when all markets are displayed. I changed the MAX for "Market 2" to be different than Market 1 and get this result:

 

 

What I'd like to see is 140 for every cell in MaxSelectedSales2.

 

  • kentyler's avatar
    kentyler
    Solution Sage
    6 years ago

    Maybe you need to remove the filter on just one market in line 3.