Calculated Column

[Anonymous]

Hello,

I have Calculated column Condition which are having True and False. I need to create custom column/measure which is based on True value if first True value then 1, for next True value then 2, and so on....

How can I achieve this?

Condition	Value
FALSE
FALSE
FALSE
FALSE
TRUE	1
TRUE	2
TRUE	3
TRUE	4
TRUE	5
TRUE	6
TRUE	7

[Icey · Accepted solution]

Hi @Anonymous ,

Just as @amitchandak mentioned, it is needed to add an index column. And then, you can also try to create a column or measure like so:

Column = 
IF (
    'Table'[Condition],
    RANKX ( FILTER ( 'Table', 'Table'[Condition] = TRUE () ), [Index],, ASC, DENSE )
)

Measure = 
IF (
    SELECTEDVALUE ( 'Table'[Condition] ),
    RANKX (
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Condition] = TRUE () ),
        CALCULATE ( MAX ( 'Table'[Index] ) ),
        ,
        ASC,
        DENSE
    )
)

 

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , You need to add an index column in the power query and then add this formula in DAX

a new column

countx(filter(Table, [index] <=earlier([index]) && [Condition] = true()), [index])