Forum Discussion

kasife's avatar
kasife
Icon for Helper V rankHelper V
2 years ago
Solved

Filter by project and date

Hi, guys   I have a difficulty, I created the following measure to dilute my goal into days in my calendar table:   Meta Diluida = VAR MesAno = MONTH(d_calendario[Date])&YEAR(d_calendario[Date...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi kasife,

    I can't access the share link, can you please paste some dummy data here with table format? We can directly copy and enter them into power bi to test coding formula.

    How to Get Your Question Answered Quickly  

    In addition, you can also try to use the following measure formula if helps:

    Total Meta Diluida =
CALCULATE (
    SUM ( d_calendario[Meta Diluida] ),
    FILTER (
        ALLSELECTED ( projetosReaal ),
        projetosReaal[Nome do Projeto Original] IN VALUES ( MetaUH[Projeto] )
    )
)

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi kasife,

I can't access the share link, can you please paste some dummy data here with table format? We can directly copy and enter them into power bi to test coding formula.

How to Get Your Question Answered Quickly  

In addition, you can also try to use the following measure formula if helps:

Total Meta Diluida =
CALCULATE (
    SUM ( d_calendario[Meta Diluida] ),
    FILTER (
        ALLSELECTED ( projetosReaal ),
        projetosReaal[Nome do Projeto Original] IN VALUES ( MetaUH[Projeto] )
    )
)

Regards,

Xiaoxin Sheng

kasife's avatar
kasife
Icon for Helper V rankHelper V
2 years ago

Anonymous  it worked. Thansks