Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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 hard coded values in it. The other field is called "Actual Premium With Time Designator" and it has a formula in it (below). Basically all this does is pull premium from different fields based on where the marketing campaign is on the response curve. Both the "Marketing Quantity" and "Actual Premium With Time Designator" fields are working as expected. I need to now create a formula field called "Premium Per Piece Mailed" that takes the "Actual Premium With Time Designator" field and divides it by the "Marketing Quantity" field. I tried this using this formula:
Actual Premium With Time Designator
@krichmond , 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.
@amitchandak - 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.