Card visual with Average of Minimum Values per ID

[Joacb761]

Hello everyone! 

I'm fairly new to PowerBI and DAX and I'm stuck on this problem!

I have a dataset set up like this:

Row Number	Client ID	Most Recent Contact or Attempt	Date	Days Since
1	A	Contact	5/15/2020	70
2	A	Attempt	6/15/2020	39
3	B	Contact	7/5/2020	19
4	B	Attempt	6/29/2020	25

 The "Days Since" column is a calculated column using Datediff between the Date column and Today().

This table is connected to another table of Employee IDs on Client IDs.

I'm hoping to create a Card Visual that displays "Average Days since last contact or attempt", which will provide the Average of "Days Since" using the most recent dates for each client ID. I'm hoping that the visual would update depending on which employee ID is selected in a filter visual.

I'm not sure if this is something that can be done with a measure or a calculated table, any assistance would be helpful!

[Icey]

Hi @Joacb761 ，

Is this problem solved?

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards,
Icey

[andre]

Click on Days Since column, go to Column Tools in the Ribbon then find Summarizatin and select Average.  Now when you drag that column to either table or matrix control or a card visual, it will show you average Days Since in the whaver filter context that you have set on the page or in the visual

to do an average of min you need to do somethigg like this:

AVERAGEX(ADDCOLUMNS(values(mytable[mycol], minVal, min(othertable[somecolumn]), minVal)

[Joacb761]

Hey! I can't seem to make sense of the Dax you provided, how would I add in Minval? I'm also not sure what column in my other table I would need to include here.

[andre · Accepted solution]

No worries, here is the link to a video that expains how to do it:

https://youtu.be/HwL5W083TCo