how to use measure as a slicer

[niuniu440]

Hi,

I have a question about how to use a measure as a visual slicer. I already calculated a measure of zscores of the target value based on other existing slicers. I created another measure to indicate if it is an outlier using: IsOutliers = IF(abs(zscore)>3, True, False). So far, it works fine. However, I cant figure out how to create a vitual sclier so I can filter between outliers and non-outliers. I read couple threads here, and create a supporting table with one column, and each row of outliers and non-outliers, but dont know how to link this table with the IsOutliers measure. I tried the method from this article, but did not work: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...

thanks!

[niuniu440]

Here is a sample of my data, the target value is 'Time Elapsed', the column of zscore and Outliers are both calculated dynamically based on the selection of 'ProjectName', 'ProjectType', and 'District'. I'd like to be able to make a slicer based on the measure of Outliers.

[Anonymous]

HI @niuniu440 ,

AFAIK, power bi not support to create dynamic calculated column based on filter/slicer. 

If you mean they are value fields and they will auto summary by current category group if you setting up aggregation mode on visual side. It mean they will auto aggregation rather than dynamic calculate based on selection.

Regards,

Xiaoxin Sheng