Forum Discussion
krichmond
Helper IV
Helper IVDAX Formula Not Returning Expected Results. Need Some Help Debugging.
I have a formula field where it isn't returning the expected results and I need help debugging it. The field leverages two other fields. One of the fields is called "Marketing Quantity" and it has ha...
amitchandak
Super User
Super Userkrichmond , if these are columns, create a measure like
PPPM (Calculated) = 'divide(Sum(This Week'[Actual Premium With Time Designator] ),Sum( 'This Week'[Marketing Quantity]))
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
krichmondHelper IV
Helper IVamitchandak - That didn't work but I am now wondering if it has something to do with the filters. Will a DAX formula automatically adjust if the chart has filters applied to it? Or will I need to embed the filter criteria into the formula itself as well? On that chart I have three filters applied.