The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
User | Count |
---|---|
69 | |
65 | |
63 | |
55 | |
28 |
User | Count |
---|---|
112 | |
81 | |
65 | |
48 | |
43 |