Forum Discussion

UserSam123's avatar
UserSam123
Icon for Helper I rankHelper I
3 years ago
Solved

column calculated in relation to another column

Hello everyone, I'm coming to you because I need help with a formula. For some time I've been trying to create a new column that would allow me to return the column created below. calculated colum...
  • tamerj1's avatar
    tamerj1
    3 years ago

    UserSam123 

    Apologies, somehow I missed your reply on this. Please try

    Measur =
    VAR CurrentIDTable =
    CALCULATETABLE (
    VALUES ( GESTION[Statut dossier] ),
    ALLSELECTED (),
    VALUES ( DOSSIER[Identifiant dossier] )
    )
    RETURN
    IF (
    NOT ISEMPTY ( GESTION ) && ISEMPTY ( EXCEPT ( { "Cancelled" }, CurrentIDTable ) ),
    IF (
    NOT ISEMPTY ( INTERSECT ( { "Accepted", "Paid" }, CurrentIDTable ) ),
    1,
    0
    ),
    0
    )

UserSam123's avatar
UserSam123
Icon for Helper I rankHelper I
3 years ago

Hello,

 

Do you know if this is possible or impossible?

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

UserSam123 

Apologies, somehow I missed your reply on this. Please try

Measur =
VAR CurrentIDTable =
CALCULATETABLE (
VALUES ( GESTION[Statut dossier] ),
ALLSELECTED (),
VALUES ( DOSSIER[Identifiant dossier] )
)
RETURN
IF (
NOT ISEMPTY ( GESTION ) && ISEMPTY ( EXCEPT ( { "Cancelled" }, CurrentIDTable ) ),
IF (
NOT ISEMPTY ( INTERSECT ( { "Accepted", "Paid" }, CurrentIDTable ) ),
1,
0
),
0
)

  • UserSam123's avatar
    UserSam123
    Icon for Helper I rankHelper I
    3 years ago

    Thanks ! 

  • UserSam123's avatar
    UserSam123
    Icon for Helper I rankHelper I
    3 years ago

    Hello,

    I'm coming back to you because I have a tiny inconsistency.

     

    Here we can see that I have two files. But neither of them has a paid/cancelled or accepted/cancelled status. So the StatusVar at the bottom should be null and not 1. Am I missing something in the measurement?