Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX

I need to create a measure for Click Events by Agent Search.The logic is

All Click Events from the Sercher = Main Portal (Sum of Contextual, Manual or Refined search events with Action = click, Action Ref = LonglinkClick, Result View = True()

 

The measure I  have written for the logic is:

 

Click Events by Agent Search = CALCULATE('Search Log specimen'[Manual Search measure]+
'Search Log specimen'[Refined search measure]+'Search Log specimen'[Contextual Search],
FILTER('Search Log specimen','Search Log specimen'[Action]="click"&&'Search Log specimen'[Action reference]="logLinkClick"
&&'Search Log specimen'[Result view]=TRUE() && 'Search Log specimen'[Searcher]="Main Portal Searcher"))

 

It just gives me blank values. Kindly help me with above measure with the logic posted above. Thanks!

Data Protection
Tutorial Requests

2 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    4 years ago

    Anonymous 

    could you pls provide the sample data and expected output?

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    Hi Anonymous ，

    According to your description, make sure the data type of the [Result view] column is True/false.

    Make sure there is a value when the conditions are met: 

    'Search Log specimen'[Action]="click"&&
    'Search Log specimen'[Action reference]="logLinkClick"&&
    'Search Log specimen'[Result view]=TRUE() && 
    'Search Log specimen'[Searcher]="Main Portal Searcher"
     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please considerAccept it as the solutionto help the other members find it more quickly.