Getting 0 for grand total on a created Measure
Hello Everyone, I feel like this is an easy fix but im abselutely stumped..... I have seen a couple of forums for items similar to this but they were slightly different/specific and i wasnt sure how to work those methods into my situation. I have created a couple of measures. 1. is to caclualte Points times Qty of items. Spec Point QTY = MIN('SageProductMaster'[Points]) * SUM('spec_credits'[qty_0]) 2. is to use the previous measure(Spec Point QTY) to calculate total points times Dollars Spec Points = [Spec Point QTY]*SUM(spec_credits[untaxed]) While these formula gave me proper results in the view i dont get a grand total for the view it just says 0 This is where i cant seem to figure out how to get Grand Totals. Please Help =]
