Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
6 years ago

Create Slicer for Measure ,

Hi ,  good day.  I have built a report which to track how many Outlets are Active or InActive , All are Tracking based on duration of 3 , 6 & 12 Months. I have created the formula for 3 months , 6...
Need Help
v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi Chanleakna123 ,

 

The slicer supports calculated column instead of measure, so you might create [Active or In-Active] using column, while you may need to click refresh button once the data changed.

 

There is another solution to filter Active or Inactive, you can create measure Filter1 like DAX below first of all, then put the Filter1 in the Visual Level Filter of Matrix visual which displays [Customer Name] and other fields, setting Filter1 as "is not blank".

 

Filter1=IF ([Active or In-Active]="Active", 1, BLANK())

 

Best Regards,

Amy

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.