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 everyone
I have this case without finding a correct solution, I have two measures that add budget and shipping, I need to another extent meet a condition and add the total result
Solved! Go to Solution.
countable =
SUMX(
VALUES('Style by Make'[Assembly Style]),
VAR _budget = Calculations[Budget]
VAR _shipping = Calculations[Shipping]
RETURN
IF ( _budget > _shipping, _shipping, _budget )
)
In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂
Hello, I hope you are well,
in the model there is a calendar table, I want to show you the comparison of the result of the model vs calculated in excel, do you have any suggestions to modify the initial code?
Greetings, thank you for your contribution.
countable =
SUMX(
VALUES('Style by Make'[Assembly Style]),
VAR _budget = Calculations[Budget]
VAR _shipping = Calculations[Shipping]
RETURN
IF ( _budget > _shipping, _shipping, _budget )
)
In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂
A worked to perfection! Thank you so much.
@Syndicate_Admin my pleasure 🙂
Please don't forget to mark that reply as a solution to help other community members find it more easily. Appreciate Your Kudos.
@SpartaBI I have been presented with an error, the fault is not identified. in cases such as the following example the total value is incorrect.
I have successfully added the code.
@Syndicate_Admin so it worked on the previous table but not when you added months to the rows?
If yes, so it's because the way it calculate in the combination of months and style. In the total there is no filters, so I guess the style has values in different months, but I would also expect to see this in the visual. Very hard to say without looking at the model itself.
Where does the column month come from? The same table?
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |