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
Molin's avatar
Molin
Helper I
3 years ago

Hi Eason, 

Thanks a lot for the help. It all make sense, except the "Online Sales" line as I cant get it to subtract the [Providers Sales]. Do I need a RemoveFilter to calculate the [Providers Sales] or how do I get it to link with the "Online Sales" row? 

Thanks in advance.