Dynamic Calculated Column based on Slicer

Question

I am trying to update a value in a calculated column using a slicer selection, to allow the user to see the effect of allowing a greater time to time to pay.

I have set up a seperate table containing the values for the slicer that is not linked and I am using the below statement

Segmentation =

IF('FinalImport'[Clearing Date] = BLANK(), "3.Poor Payers",

IF(FinalImport'[DAYS TO PAY] <= 0 , "1.Good Payers - On Time",

IF([paysegcheck] = 0, "2.Average Payers",

IF([paysegcheck] = 1 , "3.Poor Payers"))))

Pay seg check is measure which updates to a 1 or 0 based on minusing the slicer value from another field, I can see this works fine. However the Segmentation column is not updating? Can anyone help with where I am going wrong?

sturlaws · Answer

If you have a separate table,Categories, with 1 column,Category,&nbsp; and Poor, Average and Good on the rows, create a measure like this:countPrCategory =
SWITCH (
    TRUE ();
    SELECTEDVALUE ( 'Categories'[Category] ) = "Poor"; CALCULATE (
        DISTINCTCOUNT ( Table[customerID] );
        FILTER ( Table; ISBLANK ( Table[clearing date] ) || [paysegcheck] = 1 )
    );
    SELECTEDVALUE ( 'Categories'[Category] ) = "Average"; CALCULATE (
        DISTINCTCOUNT ( Table[customerID] );
        FILTER ( Table; [paysegcheck] = 0 )
    );
    SELECTEDVALUE ( 'Categories'[Category] ) = "Good"; CALCULATE (
        DISTINCTCOUNT ( Table[customerID] );
        FILTER ( Table; [days to pay] &lt;= 0 )
    );
    0
)If you also want to filter on these categories, add this measure to the filter part of the visual(s), and set it to greater than 0&nbsp;

sturlaws · Answer

Hi,&nbsp;it is not possible to update a calculated column from slicer selection, I'm afraid. You would have to handle it as a measure.cheers,S

sturlaws · Answer

yes, but it depends on what you want to achive. Do you want a list of customers and which category they are in, or the count of customers pr category? Or filter on a category?

anonymous · Answer

I want to be able to see the count of customer in each category and then use the category as a filter.

sturlaws · Answer

When using a measure in the FILTER-function, https://dax.guide/filter/, the measure is evaluated for each row in the table which is filtered. So [paysegcheck] is calculated for each row, if that was what you were worried about.

Forum Discussion

Dynamic Calculated Column based on Slicer

10 Replies

Related content

Dynamic Variable in Calculated Columns

Dynamic Rank Calculation

TMDL - calculated column

Dynamic Calculation Different Period

Dynamic Calculated Column as Visual dimension