Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I've this measure:
- Mês Atual = MAX('BD Custos Serv'[Mes])
which I use to get the most recent month, giving all the data I'm currently working with.
This next measure:
- Custo Mês Atual = CALCULATE(SUM('BD Custos Serv'[Custo])
,FILTER('BD Custos Serv', 'BD Custos Serv'[Mes]='BD Custos Serv'[Mês Atual]))
should give me the summed up cost for that current month, but it gives me the total cost as it had been calculated with no filter at all.
Any help is appreciated! Thanks in advance!
Solved! Go to Solution.
@JonCastilho - Try this:
Custo Mês Atual =
VAR __MesAtual = [Mes Atual]
RETURN
CALCULATE(SUM('BD Custos Serv'[Custo]),FILTER('BD Custos Serv', 'BD Custos Serv'[Mes]=__MesAtual))
@JonCastilho - Try this:
Custo Mês Atual =
VAR __MesAtual = [Mes Atual]
RETURN
CALCULATE(SUM('BD Custos Serv'[Custo]),FILTER('BD Custos Serv', 'BD Custos Serv'[Mes]=__MesAtual))
Worked like a charm! Thanks a lot!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |