Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
I have a table
Category Count of customer in the category Total sale
1 2 5000
2 3 7000
3 5 10000
Count of customer and total sales are formulas (which contain the filter of categories). Category is a table with only those categories. There is a table with customer name (A,B,C,D,E,F,G,H,I,L) and sale for each customer.
How can I get a table where instead to have the count , I ahve the name of the customer)
So
Category count Total sale
1 2 5000
A
B
2 3 7000
C
D
F
Thanks in advance!
//Create Table and Try this
CustFromCountCategory =
UNION(
SELECTCOLUMNS('Category', "Category", 'Category'[Category], "Count", 'Category'[Count], "Total Sale", 'Category'[Total Sale]),
SELECTCOLUMNS(
FILTER('Sales', 'Sales'[Category] = EARLIER('Category'[Category])),
"Customer", 'Sales'[CustomerName]
)
)
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
Hello,
thanks for the quick response.
I try to explain it better
I have two table
Table 1
Customer Sales
A 1000
B 2000
C 1500
.....
Table 2
Category
1
2
3
4
Now to count how many customers fall in category 1,2,..., I created a formula: "count of customer", to know the total sales fall in category 1,2,,,I created a formula.
In practice these is not a field category in Table1 as well there is not a field count or total sales in Table 2
Thanks!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
99 | |
68 | |
44 | |
38 | |
29 |
User | Count |
---|---|
156 | |
92 | |
61 | |
44 | |
42 |