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'm trying to aggregate the below to the Order Number level (Test measure). This will be part of a % allocation of client invoice calculation down stream. The desired output of the Test measure will be 4006.34 for all records.
The relationship to the ISP dimension is the headache, I believe. I thought I could solve this with:
CALCULATE( SUM(ISP Total), ALL(From Company Key)), but this does not work. Any help would be appreciated.
Thanks in advance.
Hi @WCrayger ,
It's sorry that I can't understand your requirement, could you please share the sample data and expected result to us for analysis?
Best Regards,
Teige
I was able to accomplish the desired task by building a summary table:
ISP Invoice Summary = SUMMARIZE( 'ISP Invoice' ,'ISP Invoice'[Work Order Number] ,'ISP Invoice'[Extended Invoice Total Amount] )
But still want to know if there's a more efficient way to do this in a single measure statement, one that won't use as much memory as a calculated table perhaps?
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |