This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreGet Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.
Hello everyone!
I already broke my brain with a simple task.
I have transactions table with customer_id, service, transactions and dates.
I need to make a calculated column that should display if a customer pay some service by selected filters and calculate count of a customers with flag Y or N (payed or not)
| Day 1 | Day 2 | Day 3 | Day 4 | |
| Is payed P2P service = Y | 100 | 56 | 3 | 23 |
| Is payed P2P service = N | 10 | 15 | 18 | 28 |
My idea is make a simple tool to investigate crosssales over services.
The wording of the problem is hardly comprehensible (that's why you've received no answers yet). Can you please explain this in a clear fashion so that people can understand it and help you? Thanks. Before you do it, please get familiar with this: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
By the way, a calculated column can never respond to a slicer/filter. Ever.
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 1 |