Measure for Sorting which differs each month

[KW123]

Hi!

I need to build a table?? matrix?? that involves displaying each month in a singular visual. 

Each month there is a new ranking of names depending on how much $ sold.  I can't seem to figure out how to display each Month with changing names. I have tried a matrix, the problem is that the rows need to be in the values field as each month the rank will change.  (There are about 50 or so names each month, this is a small scale example)

Below is an example: 

Month	Placing	Name	$  Sold	Month	Placing	Name	$  Sold	Month	Placing	Name	$ Solc
January	1	Bob	100	February	1	Sally	200	March	1	Joan	187
January	2	Sally	75	February	2	Sam	156	March	2	Travis	178
January	3	John	50	February	3	Bob	134	March	3	Sally	154
January	4	Joan	48	February	4	Joan	123	March	4	Sam	134
January	5	Travis	30	February	5	John	100	March	5	Bob	125
January	6	Sam	10	February	6	Travis	56	March	6	John	110

Is there some sort of DAX that would be able to work with this? 

Any input would be appreciated!

[tamerj1]

Hi @KW123 

Create the following calculated table 

Placing = GENERATESERIES ( 1, 100, 1 )

Add a matrix visual. Place 'Table'[Month] in the columns and Placing[Value] in the rows. Don't panic when you see the error 😊

create the flowing measures and place them in the values of the matrix. 

Name Measure =
VAR T1 =
SUMMARIZE ( 'Table', 'Table'[Name], "@Sold", [$Sold] )
VAR NameCount =
COUNTROWS ( T1 )
VAR CurrentPlacing =
MAX ( Placing[Value] )
VAR Result =
IF (
CurrentPlacing <= NameCount,
MAXX (
TOPN (
1,
TOPN ( CurrentPlacing, T1, [@Sold], DESC, 'Table'[Name], ASC ),
[@Sold], ASC,
'Table'[Name], DESC
),
'Table'[Name]
)
)
RETURN
Result

$Sold New Measure =
VAR T1 =
SUMMARIZE ( 'Table', 'Table'[Name], "@Sold", [$Sold] )
VAR NameCount =
COUNTROWS ( T1 )
VAR CurrentPlacing =
MAX ( Placing[Value] )
VAR Result =
IF (
CurrentPlacing <= NameCount,
MAXX (
TOPN (
1,
TOPN ( CurrentPlacing, T1, [@Sold], DESC, 'Table'[Name], ASC ),
[@Sold], ASC,
'Table'[Name], DESC
),
[@Sold]
)
)
RETURN
Result

Month Measure =
IF ( NOT ISBLANK ( [Name Measure] ), MAX ( 'Table'[Month] ) )

You may also want to add the Placing

Placing Measure =
IF ( NOT ISBLANK ( [Name Measure] ), MAX ( Placing[Value] ) )