Help with DAX statement

[Brite]

Hello,

The highlighted part does not work in the DAX formula how would I count 'Final Stripe Charges'[Customer] IF Payment Frequency = "Monthly" && 'Final Count # Stripe Payments (2)'[Count] >1 (the highlighted part)??  

[Anonymous]

Hi @Brite ,

These two conditions in the highlighted part are from different tables. Given that your formula has a lot of conditions, it's better to show some sample data and explain your logic based on the sample data.

Best Regards,

Jay

[TomMartens]

Hey @Brite ,

what is the relationship between the tables

'Final Stripe Charges' and 'Final Count # Stripe Payments (2)'

and how do the two conditions of the 'Final Count # ...' relate to each other

Please condsider providing a pbix file that contains sample data, but still reflects your data model. Upload the file to onedrive or dropbox and share the link. If you are using Excel to create the sample data share the xlsx as well. Explain the expected result based on the sample data you provide.

Personally, I have my difficulties reading any code that spans multiple lines if provided as a picture, maybe you can also provide the code as code snippet by using the highlighted icon:

Regards,

Tom