Forum Discussion

snph1777's avatar
snph1777
Icon for Helper V rankHelper V
4 years ago
Solved

Microsoft Power BI, DAX : Measure inside Calculated Column; but measure depends on slicer selection

I have a tricky situation in Microsoft Power BI, and DAX language:   I am developing a new Calculated Column called Status_CC in a table called Customers; we refer to this formally as - Customers[S...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi snph1777 ,


    The problem is that calculated columns are suitable for handling static data, for example, defining expressions that are strictly bound to the current row.

     

    In the above case, part of the data in the calculated column comes from the slicer. When we press the Enter key, the calculated column performs a calculation. But when we change the slicer, the calculated column will not calculate again. The reason is that it is calculated when the in-memory database is refreshed and then stored in the model.
    Hope these help.

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
4 years ago

It's not good practice to use a measure in a calculated column.  

It definitely won't respond to a slicer since calculated columns are evaluated at refresh or data load.

  • snph1777's avatar
    snph1777
    Icon for Helper V rankHelper V
    4 years ago

    But I am seeing values in the CalculatedColumn; you cannot say that the measure is not responding inside the CalculatedColumn definition

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi snph1777 ,


      The problem is that calculated columns are suitable for handling static data, for example, defining expressions that are strictly bound to the current row.

       

      In the above case, part of the data in the calculated column comes from the slicer. When we press the Enter key, the calculated column performs a calculation. But when we change the slicer, the calculated column will not calculate again. The reason is that it is calculated when the in-memory database is refreshed and then stored in the model.
      Hope these help.

      Best Regards,
      Gao
      Community Support Team

       

      If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

      How to get your questions answered quickly -- How to provide sample data