Power BI Dax request

[AV_04]

Hi Team,

Requesting your help on the below requirement.

In the below table I have the following columns, below are the conditions:

for a particular position, there would be three codes say 1,2 and Z. If code =1 and code=2 and units < 21, then filled is 0.5,

if code = 1 and units >21 and code =2 is null, then filled is 1,

if code=Z, filled =1

I can do the above thing in switch, but unable to add in the filter for finding the earlier of position i.e to find the filled for a particular position of say A since they may be placed anywhere. something like (table[position] = earlier(table[position])

Please requesting your help in this.

Position	Code	Units	Available	Filled
A	1	40	0.5	1
A	2	0	0.5	0
B	1	20	0.5	0.5
B	2	20	0.5	0.5
A	Z	40	1	1
B	Z	40	1	1

[Jihwan_Kim]

Hi,

I am not sure how the failed measure is written, but please check the below picture and the attached pbix file.

Earlier position measure: =
CALCULATE (
    [Failed measure:],
    OFFSET (
        -1,
        ALL ( Data[Position], Data[Code], Data[Available], Data[Units] ),
        ORDERBY ( Data[Code], ASC ),
        KEEP,
        PARTITIONBY ( Data[Position] )
    )
)