Forum Discussion

hemann's avatar
hemann
Helper I
4 years ago
Solved

Reference Maximum Text into table visual

Hi,  I am wanting to create a table visual (as per below) for Top 5 series with measures. I have been successful except for 'most active state' calculation (refer circled). Below is the data used to...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    4 years ago

    hemann 

    Give this a try.

     

    Most Active State =
FIRSTNONBLANK (
    TOPN ( 1, VALUES ( 'Table'[State] ), CALCULATE ( SUM ( 'Table'[Volume] ) ) ),
    1
)

     

     

jdbuchanan71's avatar
jdbuchanan71
Super User
4 years ago

hemann 

Give this a try.

 

Most Active State =
FIRSTNONBLANK (
    TOPN ( 1, VALUES ( 'Table'[State] ), CALCULATE ( SUM ( 'Table'[Volume] ) ) ),
    1
)