Forum Discussion
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...
Apologies upfront since I’m typing this from a tablet (so no PBI Desktop to test measures etc...).
To be able to see either Active Or Inactive outlets, you can create a new table using the “Enter data” (to generate a table) with the values Active and Inactive in two rows of the table. Let’s call this table Activity Status.
make sure the table has no relationships with other tables in your model.
then create a measure which goes along the lines of:
Activity Status = IF(SELECTEDVALUE(Status Activity[column]) = “Active”, [your active measure], [your inactive measure])
Use this measure in you visual (table or whatever), and create a new slicer with the column from Activity Status table.