Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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 November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 12 | |
| 9 | |
| 8 | |
| 5 | |
| 3 |
| User | Count |
|---|---|
| 28 | |
| 21 | |
| 20 | |
| 18 | |
| 12 |