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

v-lili6-msft's avatar
v-lili6-msft
Community Support
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

That's close, but the issue is the filter on market name. The original example I provided had a max of 100 for market 1 and market 2, so it makes the output look correct, but if you change the max of market 2 to 140, this is what you end up with.