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.
Dear All,
I have been struggling with subtotal grouped by date of table Sheet1 and almost applied all the solutions available in this forum to my problem but failed. Here is the situation.
Relationship between Table: OBs and Sheet1 is Many-to-Many
#1 subprinters = IF(HASONEVALUE(Sheet1[Ship Date/Replan Ship Date].[Month]), [#1 Sub_Printer], SUMX(SUMMARIZE(Sheet1, Sheet1[Ship Date/Replan Ship Date].[Month]), [#1 Sub_Printer]))
#1 Sub_Printer = DIVIDE(AVERAGE('OBs'[SMV]) * SUM('Sheet1'[Qty]), 480*25*2*0.65)
Filters: It is not filtering department title. I have applied filter by "Printing" but looks like it is also taking others available in department title.
Best Regards.
Solved! Go to Solution.
@biengineer , Try like this with column used in table
#1 Sub_Printer = Sumx(Summarize('Sheet1', Date[Year], 'Sheet1'[Art]), calculate( DIVIDE(AVERAGE('OBs'[SMV]) * SUM('Sheet1'[Qty]), 480*25*2*0.65) ))
@biengineer , Try like this with column used in table
#1 Sub_Printer = Sumx(Summarize('Sheet1', Date[Year], 'Sheet1'[Art]), calculate( DIVIDE(AVERAGE('OBs'[SMV]) * SUM('Sheet1'[Qty]), 480*25*2*0.65) ))
Thank you so much for the close one.
#1 Sub_Printer = SUMX(SUMMARIZE(Sheet1, Sheet1[Ship Date/Replan Ship Date].[Date], Sheet1[Art]), Calculate(DIVIDE(AVERAGE('OBs'[SMV]) * SUM('Sheet1'[Qty]), 480*25*2*0.65)))
The results are quite close, now its the difference of 0.01 throughout.
Ah looks like the results are okay, its due to rounding off.
Covering 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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |