Forum Discussion
Filter into formula
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!
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])
3 Replies
Hi Anonymous ,
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.
NathanielHi 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])
Hi Anonymous ,
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
