Forum Discussion

WinterMist's avatar
WinterMist
Impactful Individual
4 years ago

Use Measure in Calculated Column

Hello -    I have a scenario where users need to be able to select a percentage value from a slicer. That selected slicer value is then used by DAX forumulas to update values in measures and calcu...
Need Help
HotChilli's avatar
HotChilli
Community Champion
4 years ago

Calculated columns are populated at refresh time.  If using a measure in a calculated column (which we should not do), the measure will have whatever value powerbi gives to it at the same time.  I don't really want to get into the value it gets because it's not a good idea to use measures in this way.

The calculated column value will not change when a slicer value changes.

  • WinterMist's avatar
    WinterMist
    Impactful Individual
    4 years ago

    HotChilli - 

     

    Thanks for educating me that the path I've been pursuing is not a good one.

    Is there an alternate path you would recommend for this situation?

     

    Business needs to be able to select continuously changing percentage values from a slicer (potentially many times per hour).  Each time the percentage value is updated, both Effective Rate & Profit Rate formulas need to immediately (not at refresh time) update their calculated values within the table visualization.

     

    Thanks again for your time.