Forum Discussion

mashmalovsky's avatar
mashmalovsky
New Member
3 years ago

Measure filtering more than it should

Hello everyone! I've made this measure:

Measure =
VAR _PAINEL = DISTINCTCOUNT(dCalendario[Date].[Mês])*11,7
VAR _SIMULADOR = DISTINCTCOUNT(dCalendario[Date].[Mês])*6
 
RETURN
            SWITCH(true();
            SELECTEDVALUE('PLANILHA LANÇAMENTO HORAS'[MODAL])="PAINEL"; _PAINEL;
            SELECTEDVALUE('PLANILHA LANÇAMENTO HORAS'[MODAL])="SIMULADOR"; _SIMULADOR;
            _PAINEL + _SIMULADOR)
 
Then I show this amount of hour by person (the person has to practice in _PAINEL and _SIMULADOR) but when the person has only one modal (either _PAINEL or _SIMULADOR) the measure is not calculating the Total (_PAINEL + _SIMULADOR) like that:

Each column is one person and each bar is a type of practice (_simulador or _painel). The measure above should not change by person, only by the amount of month. Like:

1 month the goal to each person should be 11,7+6 = 17,7
2 months = 17,7*2

 

In the graph example above, it should be a constant = 212 (17,7*12months) for every person, regardless of the amount of practice that person had.

Was that clear enough? Sorry if I wasn't clear enough.

 

Thank you!


Need Help