Get Scalar Value from SUMMARIZE

[bajimmy1983]

Hello community, How are you? 

Before post this new question, I really tried to found anything related to my issue (difficult) already posted. Also Tried to understand how it works from other sites, but failed. Could you please help me? 

From a summarized table created using DAX I want to bring the MAX value as Scalar value in order to use it inside cards, matrix with other filter contexts, etc. 

I have created (with success) the table: 

Teste =
SUMMARIZE ( TS; TS[Data]; TS[Cliente]; TS[Cargo]; "Max"; MAX ( TS[Horas] ) )

So I got the right result I want as the example below: 

DAX Table is OK

Now, please look to another manual filter I made in the DAX table: 

Max of GPA and PEUGEOT

Then, I have the visual below (matrix), but not with the desired output for each Client row:

Desired Output / Matrix

Thanks a lot in advance and cheers,

Jimmy

[v-frfei-msft · Accepted solution]

Hi @bajimmy1983 ,

To create a measure as below to work on it. If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[bajimmy1983]

Hi @v-frfei-msft 

Thank you so much for your help.