Forum Discussion
Calculation between 2 tables with conditions
OLÁ, Tenho o seguinte caso: Tabela vendas: - Meta Alcançável (é a o quanto da meta já deveria ter sido alcançado -- Meta / Dias úteis * Dias Passados) - Dias Úteis (Medida calculada a pa...
Hi mottamatheus835,
You can add an if statement to your formula with isfiltered function to check if the specific field has been filtered. Then you can parameterized the calculation formula with the different expressions to achieve dynamic switch formulas based on filter effects.
ISFILTERED, ISCROSSFILTERED – DAX Guide - SQLBI
Regards,
Xiaoxin Sheng
Hi Anonymous . I tested, but for what I want it doesn't work. I need to make the IF function see the specific fields that are been filtered. The entire column will give me a wrong Meta Alcançável.
HI mottamatheus835,
Can you please share the formula and expected result? They should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng