Forum Discussion
Measure doesn't display all cell value
I'm trying to calculate with a measure the portfolio of open orders value for a warehouse day by day, that is the value of every purchase order that has been purchased but not arrived to the warehous yet, so I made this formula with these filters:
MEASURE=
IMAGE: https://ibb.co/YQmTtF1
The problem is that it doesn't populate every day, but only few cells. I'd expect every cell of the column to be populated. Why? Is the measure wrong or is it not right to use a measure in this case?
4 Replies
Anonymous , I looked at formula and few filter are not very clear
like
YEAR ( 'F - Inventory'[Physical date] ) = 1900
|| 'F - Inventory'[Physical date] > data (date ?, is it date ?)Post that you have commented or used OR, also not clear.
The way out is to add filters one by one check which one fails.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. And conditions you want to build formula
amitchandak thank you for your answer. I deleted the commented part in the formula, I totally forgot about that.
This formula: YEAR ( 'F - Inventory'[Physical date] ) = 1900 || 'F - Inventory'[Physical date] > data
means that I want to filter by the year 1900 that is the default year of items which transaction is not yer arrived in the warehouse (otherwise it has a plausible date) or by a date that is after my relative date values in the column (so the item is arrived in a date after). This because I have to reconstruct the portfolio in the past, so every row, that is referred to a particular day has to calculate the value based on that day...
The condition are those I explained: for each day I want to see value of the orders purchased but not arrived in my warehouse yet . What I want is to have values on all the cell of the column, instead I have some day valorized and some not (see the link to image in my last post).
Anonymous Can you post sample data and expected output? Thanks.
