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
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