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

Sorry, should Work now

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

  • DANI2021's avatar
    DANI2021
    Frequent Visitor
    3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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

      • 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.