Need help to create a MODE measure on a subset of data

[Dan_Sprague]

What is the measure to calculate the MODE (value that occurs most often) of duration?

My data is like this:

salesPersonID	salesDate	salesDuration
1	7/5/2019	30
1	7/9/2019	30
1	7/23/2019	5
1	8/10/2019	5
1	8/15/2019	5
1	8/25/2019	100
2	7/5/2019	45
2	7/9/2019	30
2	7/23/2019	30
2	8/10/2019	100
2	8/15/2019	100
2	8/25/2019	30

The MODE should take into consideration sales person and date.  e.g.:

- If the end user doesn't apply any filters in the dashboard, the measure should produce "30". 

- If the end user sets a filter on sales person #1, the measure should produce "5".

- If the end user sets a filter on August, the measure should produce "100".

- If the end user sets a filter on sales person #1 and August, the measure should produce "5".

Thank you much for all guidance!

[Greg_Deckler · Accepted solution]

I wrote a Mode Single Column and Mode Multiple Column measure awhile ago:

https://community.powerbi.com/t5/forums/searchpage/tab/message?filter=location&q=mode&location=forum...

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Greg_Deckler · Accepted solution]

I wrote a Mode Single Column and Mode Multiple Column measure awhile ago:

https://community.powerbi.com/t5/forums/searchpage/tab/message?filter=location&q=mode&location=forum...