Forum Discussion

Molin's avatar
Molin
Helper I
3 years ago

Calculating groups

Dear community,  I am facing a challenge to group sales from a fairly simple table.  The table have total sales generated on both "OrderType" and "SalesChannel" which sums up to the same. Howev...
DAX
Grouped field
v-easonf-msft's avatar
v-easonf-msft
Community Support
3 years ago

Hi， Molin 

You may need create another measure like:

New Sales =
SWITCH (
    MAX ( 'Table'[Provider] ),
    "Dining-In Sales", BLANK (),
    "Pick-Up Sale", 0,
    "Online Sales", [Online Sales] - [Providers Sales],
    [Sales]
)

Best Regards,
Community Support Team _ Eason