I’ve reworked the BOL measures and provided a couple of new measures to do what you you’re wanting to achieve. A simple version and a complex version.
The complex version will give you the correct grand total (as a summation of each row in the table), as long as you keep the granularity of the cross join and subsequent summarize consistant with the table it is being used in. i.e. keep the same number of rows.
This should give you a good idea on what you need to do moving forward.
Sample.pbix (318.5 KB)
