Forum Discussion
SSAS live connection: 2 step filter
you can query SSAS using DAX so it would return a table - which would be very SQL thing to do, and I don't recommend it :)
what would more DAX focused approach is following:
1) create a measure that shows nr of engagements, e.g.
NrOfEnagements = COUNTROWS(factCustomerEngagement) -- assuming that each row is single engagement
2) crate a visual using Customer Name from dimCustomer and [NrOfEnagements ] - it will only show customers that have engaged, and the number of such actions
2) if you then use slicer to filter e.g. 'registered for webinar' in dimEngagementType it will pass the filter from the slicer to the visual, effectively showing all the customers that have made that action and the number of such actions
you could also write it explicitely like this:
NrOfRegistrations =
CALCULATE(
COUNTROWS(factCustomerEngagement),
dimEngagementType[Action] = "registered for webinar"
)or referencing the first measure
NrOfRegistrations =
CALCULATE(
[NrOfEngagements],
dimEngagementType[Action] = "registered for webinar"
)
Thanks for the response, really appreciate it. However won't those formulas just give me a count by engagement type? What i need to answer is:
Of the 5 people who registered for a webinar, what other actions did those 5 people do? How else did they engage with us?
Does that make sense?
the measure always gives different values dependng on filter context coming from visuals, report/page/visual filters etc. and how visual is structured
for your example you can use [NrOfEngagements] together with Customer Name in the visual and only use [NrOfRegistrations]<>0 in the filter of that visual
I'd suggest just trying these measures in different layouts, once you have more clear idea how you want to present the data and what to calculate we can adjust the measures
e.g. you can create measure using CONCATENATEX that would return a string of all actions for the users that have nrofregistrations>0, which is possible but is quite unusal way of presenting data
right now I'm not clear what you want to present and in which format