Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, the following formula should calculate the sum of LN(ArbeitszeitInH) if Produkt_Nr=2006.301 and so on..
Ampel301. = IF(KontElemente[Produkt_Nr]=2006301;CALCULATE(SUM('LN'[ArbeitszeitInH]));CALCULATE(SUM('LN'[Summe_Arbeits&Reisezeit])))
The Produkt-Nr ist formatted as text. It won´t work, but I´ve no clue why..
Cheers,
Felix
Solved! Go to Solution.
Hi @BachFel,
If the Produkt-Nr is formatted as text you need to change your formula to:
Ampel301. = IF ( KontElemente[Produkt_Nr] = "2006.301"; CALCULATE ( SUM ( 'LN'[ArbeitszeitInH] ) ); CALCULATE ( SUM ( 'LN'[Summe_Arbeits&Reisezeit] ) ) )
If you don't place the ampersand it will be recognized as number since your column is a text the result will not be as you need.
Regards
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @BachFel,
If the Produkt-Nr is formatted as text you need to change your formula to:
Ampel301. = IF ( KontElemente[Produkt_Nr] = "2006.301"; CALCULATE ( SUM ( 'LN'[ArbeitszeitInH] ) ); CALCULATE ( SUM ( 'LN'[Summe_Arbeits&Reisezeit] ) ) )
If you don't place the ampersand it will be recognized as number since your column is a text the result will not be as you need.
Regards
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |