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.
Hi people!
I have the following table with 10 products for 2 stores and I have a [ABC] measure (I filter by date, store, product):
STORE | PRODUCT | [ABC] |
Store 1 | 1 | A |
Store 2 | 2 | B |
Store 1 | 3 | A |
Store 2 | 4 | A |
Store 1 | 5 | C |
Store 1 | 6 | A |
Store 2 | 7 | A |
Store 1 | 8 | C |
Store 2 | 9 | C |
Store 1 | 10 | B |
How can I count by store by the measure? The expected result:
STORE | A | B | C |
Store 1 | 3 | 1 | 2 |
Store 2 | 2 | 1 | 1 |
I think the way is to create a CALCULATETABLE, but I didn't get the results yet...
Solved! Go to Solution.
Hi, @Andregewehr ;
Create measure as follow:
A = CALCULATE(COUNT('Table'[[ABC]]]),'Table'[[ABC]]]="A")
B = CALCULATE(COUNT('Table'[[ABC]]]),'Table'[[ABC]]]="B")
C = CALCULATE(COUNT('Table'[[ABC]]]),'Table'[[ABC]]]="C")
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Andregewehr ;
Create measure as follow:
A = CALCULATE(COUNT('Table'[[ABC]]]),'Table'[[ABC]]]="A")
B = CALCULATE(COUNT('Table'[[ABC]]]),'Table'[[ABC]]]="B")
C = CALCULATE(COUNT('Table'[[ABC]]]),'Table'[[ABC]]]="C")
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Share the link from where i can download your PBI file. Also, elaborate on the criteria for classifying products in A,B and C categories.
Here are the pictures, the table misconfigured
Expected results:
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 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |