how to combine 3 separate tick box into 1 ?

[admin11]

Hi All

I have individual 3 expression all working fine , it create 3 seperate selection box like below :-

May i know how to combine above 3 into 1 ?

My 3 expression as below :-

_Deal > Today 30day =

Var _Today =TODAY()

Var _Today_30 = _Today+30

return

IF ('CRM_TS'[Closing Date] >=_Today&&'CRM_TS'[Closing Date] <=_Today_30 , 1, 0)

_Deal > Today 60day =

Var _Today =TODAY()

Var _Today_60 = _Today+60

return

IF ('CRM_TS'[Closing Date] >=_Today&&'CRM_TS'[Closing Date] <=_Today_60 , 1, 0)

_Deal > Today 90day =

Var _Today =TODAY()

Var _Today_90 = _Today+90

return

IF ('CRM_TS'[Closing Date] >=_Today&&'CRM_TS'[Closing Date] <=_Today_90 , 1, 0)

Paul

[VahidDM]

Hi @admin11 

You can use Parameter and then use the output of that Parameter in your DAX expression.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[admin11]

@VahidDM 

Thank you for sharing , i have create parameter :-

deal day = GENERATESERIES(0, 90, 30)

deal day Value = SELECTEDVALUE('deal day'[deal day])

I need to count day after today using below expression :-

_Deal > Today = IF ('CRM_TS'[Closing Date] >= TODAY(), 1, 0)

So i try to insert above field = _Deal > Today to deal day Value :-

deal day Value = SELECTEDVALUE('CRM_TS'_Deal > Today)

IT Cannot work , or i don't have any idea how to link ? 

Can you advise me ?

Paul

[VahidDM]

Hi @admin11 

Try this:

_Deal > Today 30day =

Var _Today =TODAY()
deal day Value = SELECTEDVALUE('deal day'[deal day])

Var _Today_Parameter = _Today+deal day Value

return

IF ('CRM_TS'[Closing Date] >=_Today&&'CRM_TS'[Closing Date] <=_Today_Parameter , 1, 0)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[admin11]

@VahidDM 

Thank you for your advise , I get error msg :-

The syntax for 'deal' is incorrect. (DAX(Var _Today =TODAY()deal day Value = SELECTEDVALUE('deal day'[deal day])Var _Today_Parameter = _Today+deal day ValuereturnIF ('CRM_TS'[Closing Date] >=_Today&&'CRM_TS'[Closing Date] <=_Today_Parameter , 1, 0))).

[VahidDM]

@admin11 

Try this:

_Deal > Today 30day =
VAR _Today =
    TODAY ()
VAR _deal_day_Value =
    SELECTEDVALUE ( 'deal day'[deal day] )
VAR _Today_Parameter = _Today + _deal_day_Value
RETURN
    IF (
        'CRM_TS'[Closing Date] >= _Today
            && 'CRM_TS'[Closing Date] <= _Today_Parameter,
        1,
        0
    )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[admin11]

@VahidDM 

Now only one error , that is 

That is it cannot detect 'CRM_TS'[Closing Date]

i check the closong date field is there , it is date field :-

Not sure how to clear the error ?

Paul

[VahidDM]

@admin11 

Add Max and then use 'CRM_TS'[Closing Date].

MAX('CRM_TS'[Closing Date])

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[admin11]

@VahidDM 

Thank you very much for your help. one last error :-

Too many arguments were passed to the MAX function. The maximum argument count for the function is 2.

[VahidDM]

Hi @admin11 

You forgot to close the Bracket " ) " at the end of the MAX formula.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[admin11]

@VahidDM 

Now no more error. Now i am thinking how to apply the expression for my application.

My old approach , need to have individual expression for 30 day from today as below :-

Now my question is how to make use of your expression to filter the closing date ?

Hope you can advise me.

Paul

[Anonymous · Accepted solution]

Hi @admin11 ,

You can select that table visual with only the field [Closing Date] and apply a visual-level filter with the condition(

_Deal > 30 60 90 is 1) just as below screenshot. Please find the details in the attachment.

If the above one is not working, please share a simiplified pbix file(exclude sensitive data) in order to provide you a suitable solution.

Best Regards

[admin11]

@Anonymous @VahidDM 

Thank you very much for your help , it work fine now. you have help me solve many probem. i remember see your name appear many time. you must be very good staff in microsoft.