How to show only max day on report

[NavaneethaRaju]

Hi,

I created a calculcated column to find the difference, like last used.

Days= DATEDIFF('Sales Fact'[Date(DD/MM/YYYY)],TODAY(),DAY)

I want to display the marked data alone, like max days only. 

i want to omit remainig days. respective of tag id, i need to show last days used.
Tag ID= tag_usage_fact(Table)

Set ID= SET DIM(Table)
Set Name= SET DIM(Table)
Order Date= Sales Table

in this calculated column i donno how to filter only max.

Please advice i have to create any measure to manipulate the data.

[v-zhangti · Accepted solution]

Hi, @NavaneethaRaju 

Please try the following methods.

Measure =
IF (
    SELECTEDVALUE ( 'Table'[Days Not Used] )
        = CALCULATE (
            MAX ( 'Table'[Days Not Used] ),
            FILTER ( ALL ( 'Table' ), [Tag ID] = SELECTEDVALUE ( 'Table'[Tag ID] ) )
        ),
    1,
    0
)

Put Measure into Filters and set it to equal 1.

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more.

[tamerj1]

@NavaneethaRaju 

Please try this measure

Days =
VAR CurrentDate =
    MAX ( 'Sales Fact'[Date(DD/MM/YYYY)] )
VAR MinDate =
    CALCULATE (
        MIN ( 'Sales Fact'[Date(DD/MM/YYYY)] ),
        ALLEXCEPT ( 'Sales Fact', 'Sales Fact'[Tag ID] )
    )
RETURN
    IF ( CurrentDate = MinDate, DATEDIFF ( MinDate, TODAY (), DAY ) )