Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello all,
Solved! Go to Solution.
Hi @DANI2021 ,
I updated your sample pbix file(see the attachment), please check if that is what you want. Please update the formula of the measure [Total] as below:
Total =
SUMX (
ALLEXCEPT (
'Fabrikleistung',
'Fabrikleistung'[Auftrag]
),
[Factory Output]
)
|
Best Regards
Hi,
Try this measure
Total 1 = SUMX(ALLEXCEPT('Fabrikleistung','Fabrikleistung'[Auftrag]),[Factory Output])
Hope this helps.
Hi @DANI2021 ,
I can't access to your file when try to open your shared file link. Could you please grant the sufficient privilege to access the file? You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Sorry, should Work now
Hi @DANI2021 ,
I updated your sample pbix file(see the attachment), please find the details in the attachment. You can create a measure as below to get it:
Total =
SUMX (
GROUPBY (
'Fabrikleistung',
'Fabrikleistung'[Material],
'Fabrikleistung'[Hauptbuch],
'Fabrikleistung'[Auftrag]
),
[Factory Output] + [Output 521000 *-1] + [Output 522000] + [Output 522002]
)
Best Regards
This is Not quite the result i expect. I need the 315.55 in the new column at row Level.
Hi @DANI2021 ,
Please update the formula of measure [Total] as below and check if it is your expected result... You can find the details in the attachment.
Total =
SUMX (
ALLEXCEPT (
'Fabrikleistung',
'Fabrikleistung'[Hauptbuch]
),
[Factory Output]
)
Best Regards
Thank you,
Thats ist already going in the right direction. If i now add more Orders to my Data model, they will also bei aggegated. I want the sum of wach Order.
Here is my extended Data model:
https://drive.google.com/file/d/1Y7oJ6kHokZkXFpkS8DWzrftXZZeAjNZY/view?usp=drivesdk
The 1,434 ist the sum of two Orders. Gut i want to have the value for the Orders seperately. So a sum for the order 10536062 an a sum for the order 10525686.
Hi,
Try this measure
Total 1 = SUMX(ALLEXCEPT('Fabrikleistung','Fabrikleistung'[Auftrag]),[Factory Output])
Hope this helps.
Hi @DANI2021 ,
I updated your sample pbix file(see the attachment), please check if that is what you want. Please update the formula of the measure [Total] as below:
Total =
SUMX (
ALLEXCEPT (
'Fabrikleistung',
'Fabrikleistung'[Auftrag]
),
[Factory Output]
)
|
Best Regards
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
87 | |
84 | |
65 | |
49 |
User | Count |
---|---|
140 | |
114 | |
110 | |
59 | |
59 |