Forum Discussion
Calculated measure that returns a total within a table based on at least one row matching criteria?
Good afternoon! I'm relatively new to PowerBI and BRAND NEW to the message boards. I can't figure out how to make this one calculation work. I have a table with relationships between referring ...
Hello Eric,
Below is a sample data set & expected result. Within a defined market area, I want to know the total volume of the providers who send at least ONE to our providers.
Manually, I will put this in a pivot table and do a sum on the grand total column where the Y referral is greater than 0. Let me know if you need any additional context. Thanks!
Any possible guidance on this request? Still has me stumped. THanks.