cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Power Bi Masure sum based on multiple criteria

Hello all,

• I have a table with various information.
I have an order. Different material numbers are assigned to this order. In my measure, the correct number is now displayed based on the smallest criterion, i.e. the material. Now I want to have a measure that shows the sum of my current measure in the rows. The new measure should aggregate my old one based on the order.
2 ACCEPTED SOLUTIONS
Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User

Hi,

Try this measure

``Total 1 = SUMX(ALLEXCEPT('Fabrikleistung','Fabrikleistung'[Auftrag]),[Factory Output])``

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
8 REPLIES 8
Community Support

Hi @DANI2021 ,

How to upload PBI in Community

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

Sorry, should Work now

Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

This is Not quite the result i expect. I need the 315.55 in the new column at row Level.

Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

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:

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.

Super User

Hi,

Try this measure

``Total 1 = SUMX(ALLEXCEPT('Fabrikleistung','Fabrikleistung'[Auftrag]),[Factory Output])``

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.