DAX SUMMARIZE Help - works only with 01 field from table, but when we Add the second stops to work

[jr3151006]

Hi,

I have a table with too many records, we need distinct values for a selected period on a slicer.

If you take a look the image below, I'm able to do this in the visual page, using 'LATEST' and also 'LAST' feature respectivelly.

>>>> Is there a way to do the same but this using DAX?

Here is my current DAX which works as epxected but only when using for 01 field - we need group the main table by the 03 fields in order to then show all other fields in the dataset.

DAX-Table-Sumarized = SUMMARIZE(Table1, Table1[Número],"VirtualField","")

[jr3151006]

Hi @FreemanZ,

tks for quick reply and help.

You came almost there....
The 'DATE' field was wrong fullfilled with the MAX DATE for each record and not the LAST/LATEST respecting the date interval defined on the slicer.

[FreemanZ]

try to create a new table with this:

DAX-Table-Sumarized =

ADDCOLUMNS(

    VALUES(Table1[Número]),

    "Date",

    CALCULATE(MAX(Table1[Date])),

    "Consider",

    CALCULATE(MAX(Table1[Consider]))

)

[jr3151006]

I also tried the DAX 'GroupBy' but when we add other fields, the result is not as the expected....

Dax-Table-GroupBy = GROUPBY(Table1,Table1[Número],Table1[Date],Table1[Consider])