Forum Discussion

wbhite's avatar
wbhite
Helper I
3 years ago

Issue with ALLSELECTED (or something else?)

Hello all, Referencing the screenshot provided, I need a measure to show the cumulative total for "Sq Ft * Qty" on all rows.  My current measure simply shows a row-by-row calc, but what I want to se...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi wbhite ,

Please try:

SqFt x Qty for All Shown = 
SUMX(
    SUMMARIZE(
        ALLSELECTED('Products'),
        'Products'[Sq Ft],
        "sum",CALCULATE(SUM('PO Data'[Qty]))
    ),
    'Products'[Sq Ft]*[sum]
)

If that doesn't work, consider sharing some sample data or models, note to remove private data.

How to provide sample data in the Power BI Forum

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum