Forum Discussion

nj-matt's avatar
nj-matt
Icon for Helper I rankHelper I
3 years ago
Solved

Help with ALLSELECTED by specific column summarized

I think there is a solve somewhere I am not thinking, but here is what I am trying to accomplish using the ALLSELECTED dax to summarize total sales -->   Customer Product Sales Total Sales ...
Need Help
  • MohammadLoran25's avatar
    MohammadLoran25
    3 years ago

    Hi nj-matt ,

    Try this:

    Measuree =
CALCULATE (
    SUM ( CustomerProductSales[Sales] ),
    FILTER (
        ALLSELECTED ( CustomerProductSales ),
        CustomerProductSales[Product] = SELECTEDVALUE ( CustomerProductSales[Product] )
    )
)

     

    It helped? Mark it as an accepted solution.

    Regards,

    Loran

MohammadLoran25's avatar
MohammadLoran25
Icon for Solution Sage rankSolution Sage
3 years ago

Hi nj-matt ,

Try this:

Measuree =
CALCULATE (
    SUM ( CustomerProductSales[Sales] ),
    FILTER (
        ALLSELECTED ( CustomerProductSales ),
        CustomerProductSales[Product] = SELECTEDVALUE ( CustomerProductSales[Product] )
    )
)

 

It helped? Mark it as an accepted solution.

Regards,

Loran

nj-matt's avatar
nj-matt
Icon for Helper I rankHelper I
3 years ago

Success! Thanks so much, I knew it had to be something simple