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

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.