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 need help solving this issue
I have the following measure
I need that for totals instead of using the measure, only sums the results of the individual lines.
I've been trying to use HASONEVALUE, but no luck
Open to suggestions,
Omar Octaivano
Hi @ooctaviano -
Try using HASONEVALUE (or HASONEFILTER) and for the "False" expression try SUMX(Table, ItemCost*Qty_Rec). SUMX will calculate the values for each line, then add them up at the end.
If this doesn't work, please provide more information like a data model, sample data, etc. Do not do a screenshot of sample data - put it inline to the post so it is easier to copy and paste.
Hope this helps
David
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 |
---|---|
56 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
77 | |
61 | |
47 | |
17 | |
12 |