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.
Hi Community,
How to make this in a better format, it´s working but repeating every <> makes no sense for me as I´m using the same table/column
Also I need to convert from WholeNumber to Text how I can acomplish it using Wholenumber?
Thanks.
SomaDespesasValorNominal =
CALCULATE(
SUM('BI-Financeiro-Despesas'[ValorNominal]),
USERELATIONSHIP('BI-Financeiro-Despesas'[DataEmissao], Calendario[Date]),
FILTER (
'BI-Financeiro-Despesas',
('BI-Financeiro-Despesas'[Documento] <> "CH PRE DATADO" && 'BI-Financeiro-Despesas'[CodBanco] <> "80018" && 'BI-Financeiro-Despesas'[CodClassePagamento] <> "76" && 'BI-Financeiro-Despesas'[CodClassePagamento] <> "98" && 'BI-Financeiro-Despesas'[CodClassePagamento] <> "107" && 'BI-Financeiro-Despesas'[CodClassePagamento] <> "991" && 'BI-Financeiro-Despesas'[CodClassePagamento] <> "992" && 'BI-Financeiro-Despesas'[CodClassePagamento] <> "993" && 'BI-Financeiro-Despesas'[CodClassePagamento] <> "994" && 'BI-Financeiro-Despesas'[CodClassePagamento] <> "995" && 'BI-Financeiro-Despesas'[CodClassePagamento] <> "996" && 'BI-Financeiro-Despesas'[CodClassePagamento] <> "997" && 'BI-Financeiro-Despesas'[CodClassePagamento] <> "998" && 'BI-Financeiro-Despesas'[CodClassePagamento] <> "999"
)))
Solved! Go to Solution.
If there is no misunderstanding, this shall work:
SomaDespesasValorNominal =
CALCULATE(
SUM('BI-Financeiro-Despesas'[ValorNominal]),
USERELATIONSHIP('BI-Financeiro-Despesas'[DataEmissao], Calendario[Date]),
FILTER (
'BI-Financeiro-Despesas',
('BI-Financeiro-Despesas'[Documento] <> "CH PRE DATADO"
&& NOT 'BI-Financeiro-Despesas'[CodBanco] IN { "80018", "76", "98", "107", "991", "995", "996", "997", "998", "999"}
)
)
)
You can also maintain a table for the values you want to filter out. It would be even better.
If there is no misunderstanding, this shall work:
SomaDespesasValorNominal =
CALCULATE(
SUM('BI-Financeiro-Despesas'[ValorNominal]),
USERELATIONSHIP('BI-Financeiro-Despesas'[DataEmissao], Calendario[Date]),
FILTER (
'BI-Financeiro-Despesas',
('BI-Financeiro-Despesas'[Documento] <> "CH PRE DATADO"
&& NOT 'BI-Financeiro-Despesas'[CodBanco] IN { "80018", "76", "98", "107", "991", "995", "996", "997", "998", "999"}
)
)
)
You can also maintain a table for the values you want to filter out. It would be even better.
Hi Thanks,
The suggestion to create a table with filters is good, and using NOT and IN is the solution.
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |