Forum Discussion

gjensen's avatar
gjensen
Frequent Visitor
3 years ago

Filter referencing Measure being ignored

The measure below always returns no values even though I know based on the criteria shown I should have some records flagged.  The piece that's preventing it from working properly is the FILTER(Char...
Need Help
Tutorial Requests
amitchandak's avatar
amitchandak
Super User
3 years ago

gjensen , Try like

 

Stopped TV Upgrade Customers =

CALCULATE( Countx(filter( Values(Charges[Charge Cust#]), [New TV Upgrade Customers] = 1), [Charge Cust#]),
ALLEXCEPT(Charges,Charges[Charge Cust#]),
Charges[CHG_DATE] >= SELECTEDVALUE(Campaign[EndDate]),
Charges[CHG_DATE] <= SELECTEDVALUE(Campaign[End Date + 120]),
Charges[CHG_DESC] IN {"Ultra TV", "Advanced TV", "Complete TV", "Local Plus TV"},
Campaign[Campaign_Reason__c] = "Cross sell – Upgrade TV",
Charges[ACTION_FLAG] = "START"
)

gjensen's avatar
gjensen
Frequent Visitor
3 years ago

amitchandak  Here is a link to the file. I hope this is of more use.
https://www.dropbox.com/s/b79k3ptufdoyv6w/Marketing%20Campaigns%20Dashboard.pbix?dl=0

 

When trying to measure provided I still get "blanks" returning. In the file I have commented out the new code and forced a filter on the visual to only look at the "New TV Upgrade Customers". This shows for customer 115599 that they should be flagged for stopping their service. If the measure is referenced (as in the commented out code) the column goes blank.

currently hard coded to 1 but will not be possible in the final solution. 

 

 

Thank you again for your assistance