DAX Measure Error - if Nothing is selected in Slicers

[Invesco]

Hi Experts

Getting blank() error in my card visual if nothing is selected in either teh Region and or Area Slicer how can i amend the measure to return back total result

measure

Accounts Reached =

VAR _Overall =  DIVIDE([Shingrix],[Practices],0)

VAR _Step1 = CALCULATE(DISTINCTCOUNT('dev_shc_shingrix_activity'[P Name]),

    FILTER(ALLSELECTED('dev_shc_shingrix_activity'),'dev_shc_shingrix_activity'[Region]=MAX('dev_shc_shingrix_activity'[Region]) &&

        'dev_shc_shingrix_activity'[Area]=MAX('dev_shc_shingrix_activity'[Area]) &&

        'dev_shc_shingrix_activity'[product_name] ="Shingrix"))

Return

    IF(_Step1=BLANK(),_Overall,_Step1)

[Anonymous · Accepted solution]

Hi  @Invesco ,

You can also try the following dax:

Accounts Reached =
VAR _Overall =  DIVIDE([Shingrix],[Practices],0)
VAR _Step1 = CALCULATE(DISTINCTCOUNT('dev_shc_shingrix_activity'[P Name]), FILTER(ALLSELECTED('dev_shc_shingrix_activity'),'dev_shc_shingrix_activity'[Region]=MAX('dev_shc_shingrix_activity'[Region]) &&
        'dev_shc_shingrix_activity'[Area]=MAX('dev_shc_shingrix_activity'[Area]) &&
        'dev_shc_shingrix_activity'[product_name] ="Shingrix"))
Return
IF(    HASONEVALUE('dev_shc_shingrix_activity'[Region])&&HASONEVALUE('dev_shc_shingrix_activity'[Area]),
_Step1, _Overall)

Best Regards,

Liu Yang

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

[NikhilChenna]

Hi @Invesco ,

I think you are getting blank because of max & all selected function, 

Accounts Reached =

CALCULATE(DISTINCTCOUNT('dev_shc_shingrix_activity'[P Name]),

    FILTER('dev_shc_shingrix_activity'[product_name] ="Shingrix"))

Just try this out.

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!