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]="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()))
 
This is the logic-> Action = Search, Manual Search = False, Refined Search = True AND Action = Search, Manual Search = True, Refined Search = True, Filter Term = Not Empty.
This logic needs to implemented on DAX, I am a little new to DAX,please help
 
Getting the below error:

 

 
 
data protection
Tips and Tricks
Tutorial Requests

5 Replies

  • 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())) )

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ,

    Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

     

    Best Regards
    Lucien