DIVIDE Measure - I want to sum results

[PBrainNWH]

Here's my measure...

Cases = DIVIDE(SUM('Northwest Harvest$Value Entry'[Invoiced Quantity]),SUM('Northwest Harvest$Value Entry'[Qty UoM (Sales)]))

Here are the results...

Everything is working fine, but instead of 52.00 as the total, I'd like the sum of the column. Is this doable? 

Thanks.

[Jihwan_Kim]

Hi,

I am not sure how your dataset looks like, but please try something like below whether it works.

Cases =
SUMX (
    DISTINCT ( yourtablename[yourcolumnname_thatyouwanttoseeinthevisual] ),
    CALCULATE (
        DIVIDE (
            SUM ( 'Northwest Harvest$Value Entry'[Invoiced Quantity] ),
            SUM ( 'Northwest Harvest$Value Entry'[Qty UoM (Sales)] )
        )
    )
)

[PBrainNWH · Accepted solution]

Your post helped me get to this:

Cases = SUMX('Northwest Harvest$Value Entry','Northwest Harvest$Value Entry'[Invoiced Quantity] / 'Northwest Harvest$Value Entry'[Qty UoM (Sales)])

[PBrainNWH]

The column I want to total is Cases. Right now, the calc for Cases is working on each line, but the total is dividing Qty UoM (Sales) by Invoiced Quantity as well, and I want to see the Cases total as the sum of the column. When I use the expression you offered, and put Cases as 'yourcolumnname_thatyouwanttoseeinthevisual' Cases isn't showing as an option to include in the calc.