Filter into formula

[rutag]

Hi, could anyone help me with this problem..

I need to write formula witch takes filter value and used it in a formula. For example:

Filter of works: 

1. Work A

2. Work B

My formula should be: if (selected filter value is "work A", sum( all (table [random value])) * 0,7, if selected filter value is "work B", sum( all( table [random value])) * 0,3, blank () )

Thank a lot for the help!

[Nathaniel_C]

Hi @rutag ,

IF(myTable[column] = "work A", SUM(table[random value] *0,7,IF(myTable[column] = "work B", SUM(table[random value] *0,3)

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel 

[rutag · Accepted solution]

Hi @Nathaniel_C,

Thanks for your help, but this didn't work for me, because in "myTable[column]" I have wrong data from accounting program. That's why if I choose A or B work I need to split all costs by proportion of 0,7 and 0,3.

I add my solution:

work costs = if(SELECTEDVALUE('2019 details'[Work])="work A";CALCULATE(SUM('2019 details'[SUM])*0,7;all('2019 details [work]); if(SELECTEDVALUE('2019 details'[Work])="work B";CALCULATE(sum('2019 details'[SUM])*0,3;all('2019 details '[Work]); CALCULATE(sum('2019 details'[SUM]);all('2019 details '[Work])

[Icey]

Hi @rutag ,

Glad to hear that. Please accept your reply as a solution so that people who may have the same question can get the solution directly.

Best Regards,

Icey