Forum Discussion
caslus
Helper I
Helper IMax 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 thos...
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] ) )
caslusHelper I
Helper IDont work ðŸ˜
This mensure take just the max num_dpl. In this example I have 2 num_dpl, but in real case I have more than 1.000 distinct num_dpl.
amitchandak I put new archive and new exemple.
amitchandak
Super User
Super UserI 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]
)
)- caslus