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 have a table showing a category in each row, and I created a semi additive measure of a specific calculation for each category.
All categories are present in 4 different stores, so each store has the same categories.
The semi additive measure calculates perfectly when the store slicer is selected all, but once I choose one store only, the semi addidtive measure returns the average of all three categories in each row.
The first image is before selecting a specific store, the second is after selecting a specific store.
Thank you
Hello @-SAK- ,
maybe you want to share the measure, more information or the file with us?
That would make it easier to analyze what could be the reason...
Best regards
Denis
Thanky ou @selimovd for your reply.
The thing is, I'm not being able to create a similar file like the original one I have, the one I'm creating doesn't make the same problem I have in the original, which means I might have some sort of incorrect data modelling.
I also can't share my original file 😕
Here is the measure:
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |