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.
Hello,
I'm making an ABC analysis report and couldn't show total product number for each group in matrix visual. When I do it for total value of products, it shows correct numbers but for quantity it shows total result for each group.
I guess I should use calculate but I don't how to use it in my case. I created a new measure with calculate function but couldn't figure out how to add two criteria to measure.
I need to show quantity based on group and stock availability. my columns are in same table.
regards
Solved! Go to Solution.
Hi @calerof,
This if the first time I'm using power bi.
I have several workbooks and I extract data from them via calculated column ( with lookupvalue) to my main table. Then I made some basic math calculations, still with calculated columns. There's no measure in my screenshots, but when I tried to write the measure so I can post, I figured my mistake.
I didn't add "count" function to my measure, when I added it works.
Hi @calerof,
This if the first time I'm using power bi.
I have several workbooks and I extract data from them via calculated column ( with lookupvalue) to my main table. Then I made some basic math calculations, still with calculated columns. There's no measure in my screenshots, but when I tried to write the measure so I can post, I figured my mistake.
I didn't add "count" function to my measure, when I added it works.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |