Forum Discussion

ImJustConfused's avatar
ImJustConfused
Frequent Visitor
8 years ago

Creating a dynamic calculated column via slicer

I'm trying to create multiple slicers to filter my data. The first slicer is a date slicer. The second slicer is a count slicer. I have a categorical field, a binary field, and a date field. Similar ...
ImJustConfused's avatar
ImJustConfused
Frequent Visitor
8 years ago

Mareias Thank you for the suggestion. 

 

I've tried using a calculated Measure, but I am unable to use that Measure in a slicer. Is there a different way that would help me achieve the same result?

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi ImJustConfused,

 

You should manually create an extra table which is unrelated to fact data table to list all available count numbers for users to choose from.

 

Create measures like below:

NameCount = 
CALCULATE(
    COUNT('Test Table'[name]),
    'Test Table'[isOld] = 1,ALLSELECTED('Test Table'[Date]))+0

selected CountNo = SELECTEDVALUE(slicertable[CountNo])

check_ = IF([NameCount]=[selected CountNo],1,0)

Add measure [check_] to visual level filter and set its value to 1.

 

Best regards,

Yuliana Gu