Hello All, complete noob here, just about halfway through the first level of guided learning. I feel hands on playing around is just as useful as formal instruction. Here is my question, (yes i searched the community and no I couldn't find it, not saying its not there, just I didn't find it.) Anyway, I have a data set of employee expenses, I have Slicer 1 to filter by Employee, and Slicer 2 to filter by expense type, ie (airfare, meals, hotel, office supplies, etc. ). I want to create a visual card that will display the average as a result of the slicers, I do no how to use "Edit Interactions" but the problem is I am not that familiar with DAX yet and I cant get any formulas to work. Currently, slicer 1 can select multiple people, but slice 2 can only do 1 expense at a time. Here is an example of what I am trying to accomplish.
Sample Data Set (take note the bar visual current shows Jack and John, with the values 1000, and 2600 respectively
Emp Exp Type Amount Slicer 1 Slicer 2 Card Visual (average of airfare for the people selected)
Jack Airfare 600 x Jack Airfare 600 (average of jack and johns airfare by occurance)