Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a column which look like this:
Category |
new order |
old order |
cancelled order |
pending |
cancelled order |
new order |
new order |
pending |
new order |
pending |
What I want is that I want to make a measure total of each one in that category column.
For example new order = 120
pending = 200
Solved! Go to Solution.
Hi @selected_ ,
Please create a measure like this.
Measure = COUNT(Sheet5[Category])
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@selected_ , A measure like
Sumx(Table, Switch( True() , [Category] = "new order" ,120 , [Category]="pending ",200,0))
I don't have the values of each one in that category that's why I wanna calucate a measure count on how many "new order" or "pending" are in that category.
@selected_ ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
The column in my dataset look like this, new order and pending with more than one records
Category |
new order |
new order |
new order |
new order |
new order |
new order |
pending order |
pending order |
pending order |
What I for output it gonna count amount new order and pending in each column order in to a new table like this
Category | Total |
new order | 6 |
pending order | 3 |
Hi @selected_ ,
Please create a measure like this.
Measure = COUNT(Sheet5[Category])
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |