Filter by project and date

[kasife]

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])
VAR ProjetoSelecionado = SELECTEDVALUE(projetosReaal[Nome do Projeto Original])

RETURN



IF(
    d_calendario[Dias de trabalho]=1,
        DIVIDE(
            CALCULATE(
                SUM(MetaUH[Meta Desafio]), 
                    FILTER(
                        MetaUH, 
                        MetaUH[Mes ano formula padrão] = MesAno || MetaUH[Mes ano formula padrão] = ProjetoSelecionado
                        )
                ), 
                [Dias uteis Mês])
                )

And then I added it up and I'm using it in my visuals

Total Meta Diluida = 
VAR ProjetoSelecionado = SELECTEDVALUE(MetaUH[Projeto])

RETURN

CALCULATE(
    SUM(d_calendario[Meta Diluida]),
    FILTER(
        projetosReaal, 
        projetosReaal[Nome do Projeto Original] = ProjetoSelecionado
    )
)

When I do the filter by selecting date, it works, but when I select the project, the measurement remains static. How could I adjust this?

[v-shex-msft · Accepted solution]

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]

@v-shex-msft  it worked. Thansks

[amitchandak]

@kasife , Please share sample data and expected output.
But the approach of following should help

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU


Matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs

[kasife]

@amitchandak Thank you very much for your feedback. Follow the link

https://ufile.io/bxgcjw55