Forum Discussion

DANI2021's avatar
DANI2021
Frequent Visitor
3 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    Try this measure

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

    Hope this helps.

DANI2021's avatar
DANI2021
Frequent Visitor
3 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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