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 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.
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |