Forum Discussion

Nini1's avatar
Nini1
Frequent Visitor
4 years ago
Solved

How Slicer Filter can affect column calculations?

Hello everyone,   I'm a new user of Power BI and need your help to solve the problem. I have a data of customer who have unique identifier and corresponding date field.   I want to create ...
  • amitchandak's avatar
    amitchandak
    4 years ago

    Nini1 , Ideally these should work from Max and min

    maxx(allselected(tbl) , tbl[date])

     

    minx(allselected(tbl) , tbl[date])

     

    But if slicer is on another table try like

    maxDateAll=
    Var _max = maxx(allselected(Date) , Date[date])
    Var _min = minx(allselected(Date) , Date[date])
    return
    CALCULATE ( MAX ( tbl[date] ), filter(ALLSELECTED(tbl), tbl[date] <= _max && tbl[date] >= _min))

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Nini1 ,

 

No, it's not possible. Since calculated column is static, it could not be dynamically changed based on the selection in slicer.

 

For your case, please use the same syntax to create measure instead:

max = CALCULATE(MAX('Table'[date]), ALLSELECTED('Table'))

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you, this solved my problem as well that no one on community could answer!

  • Nini1's avatar
    Nini1
    Frequent Visitor
    4 years ago

    Thank you very much!

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Nini1 ,

       

      Thanks for your feedback, you are welcome😀

       

      Best Regards,
      Eyelyn Qin