Hi Team,
I'm quite interesting of one thing.
I have a two measures to calculate Total amount of Cost:
NCR Cost Line Item = (SUM('NCR_Report'[qty])*(((SUM('PV LE'[prod_cost])+SUM('PV CU'[prod_cost]))/5.2)+SUM('PV FE'[prod_cost])))
NCR Cost =
VAR __table = SUMMARIZE('NCR_Report',[shift],[fabric_name],[defect],[qty],"__value",[NCR Cost Line Item])
RETURN
IF(HASONEVALUE('Master Batch'[mfg_ord_no]),[NCR Cost Line Item],SUMX(__table,[__value]))
Data are collected from 4 queries with relation through Master Batch table (my uniqe values).
For the first view everything seems to be OK but I noticed that not all rows in my table has calculated cost as below:
Missed data for three rows are collected from table PV FE. They are visible as there is a number in column "mfg_ord_no".
Any idea why it happened ?
Solved! Go to Solution.
I investigate measure and the issue wasn't in measure itself. Measure works properly but issue was in filtering applied on graph & site level including relation with calendar. It's fixed.
One of your measure steps returns BLANK(). To investigate you can use the new EVALUATEANDLOG() function.
I investigate measure and the issue wasn't in measure itself. Measure works properly but issue was in filtering applied on graph & site level including relation with calendar. It's fixed.
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
231 | |
51 | |
48 | |
46 | |
45 |
User | Count |
---|---|
282 | |
212 | |
113 | |
82 | |
72 |