Forum Discussion

Oded-Dror's avatar
Oded-Dror
Icon for Helper III rankHelper III
4 years ago
Solved

Dynamic value in calculated column

Hi there, Please take a look at this picture (AdventureWorksDW) And tell me if this is possible to store value in calculated column based on dynamic value from a measure. I've try (see my code) bu...
Need Help
  • jeroendekk's avatar
    jeroendekk
    4 years ago

    Hi Oded-Dror 
    Calculated columns and tables are calculated on refresh and after that they are static.

     

    So a slicers will impact which rows of a table are used but not the content itself. A measure could create this result, but you cannot use measure results in a slicer.

    So sorry I do not think this is possible.

    Best regards,

    Jeroen Dekker

Oded-Dror's avatar
Oded-Dror
Icon for Helper III rankHelper III
4 years ago

Is AdventureWorksDW database wich I added Calculated column to the product table

Sub Category Value = 'Product'[Subcategory] & " (" &
Format( CALCULATE([Revenue],
Filter('Product','Product'[ProductKey] = EARLIER('Product'[ProductKey])),
KEEPFILTERS(Customer)
), "#,##") & ")"
 
When I put it in a slicer it show total per subcategory not respecting the Customer Country-Region filter
Revenue is SUM(Sales[Sales Amount]) (Link below the image)