Forum Discussion
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 ...
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.
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.