Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Couldn't load the data for this visual

There is an error with the below DAX measure,Kindly help   Refined search measure = Calculate(count('Search Log specimen'[Action]), FILTER('Search Log specimen','Search Log specimen'[Action]="S...
data protection
Tips and Tricks
Tutorial Requests
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , check data type of manual search

 

Try like

 

Calculate(count('Search Log specimen'[Action]),
FILTER('Search Log specimen','Search Log specimen'[Action]="Search" && 'Search Log specimen'[Manual search]= false() && 'Search Log specimen'[Refined search]=True() ),
filter('Search Log specimen','Search Log specimen'[Action]="Search" && 'Search Log specimen'[Manual search]=True() &&'Search Log specimen'[Refined search]= True() && 'Search Log specimen'[Filter terms] <> BLANK()))

 

Assumed boolean data type

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi amitchandak ,

 

Thanks for sharing. The error has been rectified. However I am not getting any values & its blank.Could you help me with the measure please.

 

The below is the logic,please help me with the DAX measure

 

Refined Search =Action = Search, Manual Search = False, Refined Search = True AND Action = Search, Manual Search = True, Refined Search = True, Filter Term = Not Empty.

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , Try OR

     

    Calculate(count('Search Log specimen'[Action]),
    FILTER('Search Log specimen', ( 'Search Log specimen'[Action]="Search" && 'Search Log specimen'[Manual search]= false() && 'Search Log specimen'[Refined search]=True() ) ||
    ('Search Log specimen'[Action]="Search" && 'Search Log specimen'[Manual search]=True() &&'Search Log specimen'[Refined search]= True() && 'Search Log specimen'[Filter terms] <> BLANK())) )

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you very much. Sure will try