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 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.
  • https://drive.google.com/file/d/1yAOp9Rs3I7Lgbm6bOO_sKb84IjRSPM4Q/view?usp=drivesdk
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.

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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

      • 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