Forum Discussion

caslus

Helper I

6 years ago

Solved

Max date and value by date filter slicer (dinamic)

The archive : https://transfernow.net/215t88x2cpeh

This is my table... and my filter:

If I put the filter 13/8/2019 to 5/09/2019... I want show just the yellow part and make a sum of those values 138.435,19 + 95.596,61of max date by filter:

15129 05/09/2019 138.435,19
15366 05/09/2019 95.596,61
----- ------------ 234.031,80

If i change the filter... 13/08/2019 to 26/09/2019

15129 26/09/2019 140.254,42

15366 13/08/2019 94.205,11
----- ----------- 234.459,53

-- Edit..

Total in this case need be : 235.937,66

Thaks----------

Edit 09/01/2020

new archive : https://transfernow.net/115z99t4ires
I have/ I need

MY DATA-----------

My data

I NEED THIS RESPONSE BELOW

I NEED THIS RESPONSE

MY DATA-----------

My data

I NEED THIS RESPONSE BELOW

I NEED THIS RESPONSE

MY DATA-----------

My data

I NEED THIS RESPONSE BELOW

I NEED THIS RESPONSE

MY DATA-----------

My data

I NEED THIS RESPONSE BELOW

I NEED THIS RESPONSE

I got a new measure, It seems to give correct GT and correct values when view NUM_DPL. But when view by NUM_DOL and date , it does not show correct value, figuring out that

Total value = Calculate(
    sumx(  
        ADDCOLUMNS( 
            SUMMARIZE(
                data,
                data[NUM_DPL],
				"max_date",
				MAX( 'Date'[Date]),
                "Max_ID", max(data[NUM_DPL])
            ),
            "_num",
            calculate(
                Max(data[VLR_SLD_TOT_CAL]),
                filter(
                    (data),
                    data[NUM_DPL]= [Max_ID] && data[DAT_REF]= ([max_date]) )
                )
            )
        ,[_num]
    )
)