I’m trying to come up with a measure to calculate the count of “Work Items ID’s” in a certain state for a selected month. The issue is that, as long as the Work item stays in the same state, there is no data available (so whenever there is no data, the state from the latest available date needs to be taken into account).
In example below I want to calculate how many work items are in state 4 in month “2023-01”
For Item 12 it is clear, but for item 10 there is no value -> looking at previous known month we see that is was (and is) in state 4

As a long time Tableau user I’m still learning how to use Dax to create measures and columns in Power BI. I have the unique_id for each person and this id is generated several times based on location and Type. See my data below:

I have the unique_id for each person and this id is generated several times based on location and Type. I utilize the following code DistinctCount(Table1[unique_id]) and this returns all the ids instead of the unique ones.