Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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])

     

     

     

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

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.
Nathaniel 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Icey
      Community Support
      6 years ago

      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