Forum Discussion

aucklanduser's avatar
aucklanduser
Icon for Helper I rankHelper I
7 years ago
Solved

Dynamic custom column workaround

Hi all,   I realise that custom columns are only generated at data refresh so can't be used with slicer selectvalues however I am at a loss as to how to incorporate the slicer selection into my mod...
Need Help
Tips and Tricks
  • aucklanduser's avatar
    aucklanduser
    7 years ago

    Thanks for the reply Yuliana, this doesnt work unfortunately with my data as I need to run a calculation at row level then aggregate into categories.

     

    I have found a solution by making a measure with a combintion of SUMX and ADDCOLUMNS. This runs the calculation by row level and can still be aggregated by category and run the sum correctly (rather than just running the calculation on the category totals).

     

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
7 years ago

You can use a Calculated Column as a slicer. It is one of the few times using a calculated column makes sense, assuming you cannot get the same result in the source table (via Power Query, or at the true data source).

 

You cannot use a measure as a slicer though.

aucklanduser's avatar
aucklanduser
Icon for Helper I rankHelper I
7 years ago

Hey edhans,

 

Sorry, not meaning use it as a slicer but have the slicer value drive the measure/calculated column. 

Below is an example of my working measures that I cant replicate as columns