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 everyone,
I have been trying to solve this for days now but unfortunately have not been able to find a solution yet. I want to count all products where I have increased my market share with a specific customer group.
I have multiple customers [Customer] that belong to the same customer group [Customer Group]. The groups are specified in a column in the source table. The source table also includes the name of the product [Product], my market share in the current year [MS CY] and my market share in the previous year [MS PY] with the specific customer [Customer].
I have created a measure that calculates my market share YoY [Market Share Delta in pp] with the specific customer.
I am now trying to have a card visual that displays the number of products with [Market Share Delta]>0
I have tried a visual with [Product} as value (set to count distinct), which is filtered by [Market Share Delta} is greater than 0. However, for some reason I cannot filter the visual with the measure. So I have gone forward and created a column that calculates the market share YoY. When I filter it by that, it still gives me 71 instead of 24.
I tried to use a measure for it as well, with the following DAX formula:
@Anonymous ,
This issue should be related to the table structure and table relationship in your report. Could you share some sample data(dummy data) for further analysis?
Regards,
Jimmy Tao
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |