I'm having an issue with a measure on Dynamic 365 customer insight(data). The measure is called total store spending and it is calculated by ( functiontype: sum) (Measure Expression: POSPurchase_POSPurchases.TotalPrice ). The other measure called total online spending works fine and it is calculated by ( functiontype: sum) (Measure Expression: OnlinePurchases_OnlinePurchases.TotalPrice ). There are 2 dimensions for total online spending which are (CustomerInsights.CustomerId and OnlinePurchases.ContactId). What is the right dimension I need to make total store spending work? Right now no value is being displayed because the current dimension are (CustomerInsights.CustomerId and POSPurchase.PurchaseId)
What adjustment should I make to resolve the issue with displaying values for the /Total Store Spending/ measure?