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.
I know I am close but is there a way for me to get the 1,473 total value for customer 8 to appear on every row even when I add the items to it?
Here is the equation I am currently using. It works until I add Item
Solved! Go to Solution.
Hi @Anonymous ,
Please use the following measure:
Measure = calculate (
SUMX(
SUMMARIZE('Invoice Variance','Invoice Variance'[cust_num],
"CustStart",SUM('Invoice Variance'[volume])),[CustStart]),REMOVEFILTERS('Invoice Variance'[item])
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
@Anonymous , Try a measure like
calculate(SUM('Invoice Variance'[volume]),FILTERS(allselected( 'Invoice Variance'), eomonth('Invoice Variance'[inv_date],0)= eomonth(max('Invoice Variance'[inv_date]),0)))
That doesn't work because I using these variables to filter the information to only between the two dates the end user selects from the created Date Table. It also needs to be fixed at the Customer Num level as a subtotal essentially despite me adding the underlying items:
Hi @Anonymous ,
Please use the following measure:
Measure = calculate (
SUMX(
SUMMARIZE('Invoice Variance','Invoice Variance'[cust_num],
"CustStart",SUM('Invoice Variance'[volume])),[CustStart]),REMOVEFILTERS('Invoice Variance'[item])
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
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 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |