Forum Discussion
Help Needed - Dax Measure
If the data is linked you might be able to achieve the total you are looking for with slicers and page level filters.
Ex. If you select AUS in a location slicer you could then filter to the job class and display the total in a card visual.
I've done this with a scenario (I beleive is somewhat similar) where I wanted to display the total number of leads through filtering an account, then by the account owner.
Thank you... I was able to get the info that way, but our Directors didn't want to have C-Levels using page filters everytime they needed to change a site.
Anonymous wrote:If the data is linked you might be able to achieve the total you are looking for with slicers and page level filters.
Ex. If you select AUS in a location slicer you could then filter to the job class and display the total in a card visual.
I've done this with a scenario (I beleive is somewhat similar) where I wanted to display the total number of leads through filtering an account, then by the account owner.
I'm not sure how to create the dax measure, but couldn't you create multiple card visuals that only display this information through page level filters?
Ex. Create a card for each of the job classes to display the total based on the location slicer filter?
I beleive that would resolve the issue of having to utilize multiple slicers.