Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I used sumx, hence i supposed to get sum of sales and extended amounts in last coulmn. However, i seeing something else. Can someone help on it. Thanks.
Solved! Go to Solution.
Hello!
I see that you are adding the data using FactInternetSales as context, which means that it will go row by row in that table doing the operation you indicated, to see that result modifies the type of summarization that the columns of ImporteVentas and ExtendedAmount have
Hello, it is the same as I explain, everything depends on the filter context, when you remove the Sales order number everything is damaged because you removed the context from the matrix and therefore it is adding the data, basically it is adding all the 2.9 and it is adding them. This happens because you are directly using the columns with the measurements without a correct filter context.
If this post is helpful in helping you solve your problem, consider giving the post a thumbs up
and accept it as a solution!
Hi,
as you can see there is nothing wrong in your measure
it is only grouping all sales with the same amount.
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Hey, if my query is correct. can you pls me understand why am i seeing huge values in add measure column, while you are getting the correct 4.58 values in add measure?
Hello, it is the same as I explain, everything depends on the filter context, when you remove the Sales order number everything is damaged because you removed the context from the matrix and therefore it is adding the data, basically it is adding all the 2.9 and it is adding them. This happens because you are directly using the columns with the measurements without a correct filter context.
If this post is helpful in helping you solve your problem, consider giving the post a thumbs up
and accept it as a solution!
Hi, Can you also help me understand in detailed steps, at least for the first row, how is it calculated as 14614??
Calculated correctly after adding salesordernumber column to the table. Thank you
Hello!
I see that you are adding the data using FactInternetSales as context, which means that it will go row by row in that table doing the operation you indicated, to see that result modifies the type of summarization that the columns of ImporteVentas and ExtendedAmount have
Hey,
I already selected don't summarize only. yet i am still seeing incorrect values.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
86 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |