Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Apologies if my subject is unclear, I wasn't sure on the language to use.
I have a set of data similar to this example: https://data2actionltd-my.sharepoint.com/:x:/g/personal/aimee_laird_data2action_co_uk/EcITVcSSC6dNh9...
I think I need to do this as a calculated column rather than a measure, however open to your advice.
I am looking at the how many items were sold to a property. Depending on the item, is the sale classed as a Single or a Dual sale.
E.g.
Water + Bread = Dual
Water + Sugar = Single
Water + Bread + Sugar = Dual
Water = Single
Bread = Single
In my dashboard, I want to show:
Number of Multi sales WTD, MTD and YTD
Number of Single sales WTD, MTD, and YTD
Help please! i've tried all sorts but can't make sense of a solution.
Solved! Go to Solution.
@Aimeeclaird So try something like:
Type =
VAR __Table = FILTER('Table (13)',[Address] = EARLIER([Address]))
VAR __Items = DISTINCT(SELECTCOLUMNS(__Table,"__Item",[Item]))
RETURN
SWITCH(TRUE(),
COUNTROWS(__Items) = 1,"Single",
"Water" IN __Items && "Bread" IN __Items,"Dual",
"Single"
)
I mocked this up in attached PBIX (Table (13)) below sig.
@Aimeeclaird So try something like:
Type =
VAR __Table = FILTER('Table (13)',[Address] = EARLIER([Address]))
VAR __Items = DISTINCT(SELECTCOLUMNS(__Table,"__Item",[Item]))
RETURN
SWITCH(TRUE(),
COUNTROWS(__Items) = 1,"Single",
"Water" IN __Items && "Bread" IN __Items,"Dual",
"Single"
)
I mocked this up in attached PBIX (Table (13)) below sig.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |