Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Need DAX expression

Please Help me to create a Calculated column.

I need a DAX expression to create a calculated column.

I have two columns Status and fruit,

 I need a Calculated column for numbering differnt fruits on each status

Output Should looks like below

 

My aim is to create a Matrix as shown below

 

 

Thanks.

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Create a new column

     

    Countx(filter(Table, [fruit] = earlier([fruit]) && [Status] = earlier([Status])),[Status])