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.
In the below image, you can see that there are different results for the Fabrikam brand.
The following are the dax measures.
Fabrikam Sales= sumx(
filter(Sales,
Related(Product[Brand])="Fabrikam"
),[Sales Amount)
Contosa Sales= sumx(
filter(Sales,
Related(Product[Brand])="Contoso"
),[Sales Amount)
I know that the above DAX measures are not the correct approach. but i want to understand the context transitions issues in the above measures. Datalink Path shared.
I wanted to know why Fabrikam Sales measure value is not matching with the Fabrikam Sales Amount Value. My doubt is that if there are context transitions issues in Fabrikam Sales then the same is applicable for Contoso brand. How ContosaSales Measure is successful. Why it did not show the difference in values. I want to know the row value of fabrikam Sales that have resulted into difference of values.
This is required for understanding purposes.
Solved! Go to Solution.
So far, I localize a diffrenece here
https://drive.google.com/file/d/10R7pTMTVhI3DVZuc7e6mV7QrAWq_-G-I/view?usp=sharing
Data link Path shared
there is no access to your data sample, please, check access policy
Sorry my mistake. Please check the below link.
https://drive.google.com/file/d/10R7pTMTVhI3DVZuc7e6mV7QrAWq_-G-I/view?usp=sharing
So far, I localize a diffrenece here
from the first sight I see two options here
1. a complex measure like
Sales by Brand = calculate([Sales Amount],
ALLEXCEPT(Sales, 'Product'[Brand]))
2. a fabrikam Measure
FabrikamSales =
IF(
SELECTEDVALUE('Product'[Brand])="Fabrikam",
calculate([Sales Amount], 'Product'[Brand]="Fabrikam"),
BLANK()
)
Thank you very much.
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |