Forum Discussion
Power BI
Measure 19 = IF(COUNTROWS(VALUES('AIPL 2(Line Scan)'[MN])) = 1, SUM('AIPL 2(Line Scan)'[MN]),SUMX(VALUES('AIPL 2(Line Scan)'[MN]), 'AIPL 2(Line Scan)'[MN])) The above formula does not work when the v...
Ashish_Mathur
Super User
Super UserHi,
Share some data and show the expected result.
Hi , I have been prohibited to share anything.
For your understanding, i am explaining the scenario here.
I have two tables Production & Target. In production table i have columns namely date, order number, hour1 production, line, section . In target entry table we have column namely,date order number. line, section and target. so now i have connected both the tables on the basis of date.
Now the problem here is sometime they have same target entry in the target table so instead of giving total it shows average as you can see. for that i have used the measure which has the formula TRY = SUMX(VALUES('AIPL 2(Line Scan)'[MN]),CALCULATE(AVERAGE('AIPL 2(Line Scan)'[MN])))