Help with visual that is based on a typ of filter?

[Anonymous]

Hello, I am trying to create a visual with a yes or no option.

Lets say I have table with rows of subscriptions.

In one of the columns theres a date with when the subscription last was used. I want to use a visual with yes/no option that when yes is applied only the rows/subscriptions that either have their date-cell empty or are older than 365 days are listed. 

I have managed to do this with a measurement that looks like this with the option of YES/NO in a separate table. but I cant use it on other visuals besides the table. 

ShowMeasure =

IF (

    "Nej" IN DISTINCT (Inaktiva_val[Val]),

    1,

    IF (SELECTEDVALUE (sub_info[Inaktiv ab]) = "Inaktiv", 1, 0)

)

And the measure that marks the subscriptions as inactive (empty or 365 days or older) I then made a column with this measurement in it. 

Inaktiv =

VAR _LastDate = MAX('sub_info'[Senast aktiv]) + 0

VAR _CutoffDays = 365

VAR _DaysSinceLastUsed = DATEDIFF( _LastDate, TODAY(), DAY)

RETURN

IF(_DaysSinceLastUsed > _CutoffDays, "Inaktiv")

This only works in the table. I also have a bar chart that I want to use this one so that I can count the types of subscriptions when the option yes/no is used.

[Anonymous]

Hi @Anonymous 

You can create a table 

e.g 

Then put it to a slicer. then create a measure.

e.g 

Inaktiv =
VAR _LastDate = MAX('sub_info'[Senast aktiv]) + 0
VAR _CutoffDays = 365
VAR _DaysSinceLastUsed = DATEDIFF( _LastDate, TODAY(), DAY)
RETURN
IF(ISFILTERED('Table'[Type])=FALSE(),...,
IF(MAX('Table'[Type])="Yes",IF(_DaysSinceLastUsed > _CutoffDays, "Inaktiv")))

Best Regards!

Yolo Zhu

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