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 , Measure has to filter by dimension or grouped value

 

example

FILTER(customer, [New TV Upgrade Customers] = 1).

 

Sumx( FILTER(values(Charges[name]) , [New TV Upgrade Customers] = 1) , [Measure] )

 

you can check the example

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q

gjensen's avatar
gjensen
Frequent Visitor
3 years ago

amitchandak Thank you for the reply.
I'm just a bit confused on the direct application to my data.

 

I can use the sumx measure to show the "New TV Upgrade Customers" but I need to then filter those customers using the logic shown in the Stopped TV Upgrade Customers measure. 

I tried adding it's logic to my existing measure but said a True/False expression doess not specifcy a column (unsure where it's coming from)


Is this close? The "return" piece has the correct logic IF I can get it to look at just the values flagged in the New TV Upgrade Customers measure. 

 

  • 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