How to sort revenue of latest day in Matrix.

[arvindyadav]

Hi Team,

I need to sort sum of revenue of the last day in descending order in matrix table how to do in Power BI?

[v-lid-msft]

Hi @arvindyadav ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft · Accepted solution]

Hi @arvindyadav ,

We can create a measure as sum to meet your requirement.

SumValue = 
VAR t =
    CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table' ) )
RETURN
    IF (
        HASONEVALUE ( 'Table'[Date] ),
        SUM ( 'Table'[Vaule] ),
        CALCULATE ( SUM ( 'Table'[Vaule] ), FILTER ( 'Table', [Date] = t ) )
    )

If it doesn't meet your requirement, Please show the exact expected result based on the Tables that We have shared.

Best regards,

[parry2k]

@arvindyadav unfortuntely it is not possible, I think there is an idea for this on ideas forum, please vote for it.