Forum Discussion
Solved
Missing Data in inputs resulting in blanks on Matrix
Hello, For certain warehouses, data does not exist. It isn't 0-- it is non-existent. Thus, changing values from null to 0 doesn't work since it really isn't null- it doesn't exist. As a result, i...
Should have mentioned that this is a calculated column. If you must use a measure, add some calculation like MAX() or SELECTEDVALUE(). If you need the totals to work then you need to use an aggregation function like SUMX()
Measure = var a = SUMMARIZE('Table 2','Table 2'[Plant],'Table 2'[Product],"sm", CALCULATE(sum('Table'[Inventory]),TREATAS({([Plant],[Product])},'Table'[Plant],'Table'[Product]))) return 0+sumx(a,[sm])
i am stuck here. It is odd that your file accepted 'plant' and 'product' but when i do it, it doesn't seem to like it. it seems like it almost only accepts measures and since plant and product aren't measures, it rejects.
Should have mentioned that this is a calculated column. If you must use a measure, add some calculation like MAX() or SELECTEDVALUE(). If you need the totals to work then you need to use an aggregation function like SUMX()
Measure =
var a = SUMMARIZE('Table 2','Table 2'[Plant],'Table 2'[Product],"sm",
CALCULATE(sum('Table'[Inventory]),TREATAS({([Plant],[Product])},'Table'[Plant],'Table'[Product])))
return 0+sumx(a,[sm])IT WORKED!!! Thank you so much.