Forum Discussion

lkarthick24's avatar
lkarthick24
Regular Visitor
3 years ago

Summarize Table with multiple selected slicer

Hi,
Is it possible to link slicer to summarize table in power bi desktop?

if possible,i have a column from same table used as slicer. is it possibpe to pass output of slicer (Multi select output) to summarize table. I have to find Max date from the selected two date.

regards,

LK.

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    lkarthick24 , You have to create join to filter automatically (prefer only if 1-M , Many on New fact/table side)

     

    Or create measure like

     

    measure = calculate(Sum(NewTab[Value]), filter(NewTab, NewTab[Column] in values(Dim[Column]) ) )

  • lkarthick24's avatar
    lkarthick24
    Regular Visitor
    3 years ago

    Hi,

    Thanks for the quick replay. I have to find the max date and min date from the selected slicer and pass the value to summarize table.

    regards,

    LK

  • lkarthick24's avatar
    lkarthick24
    Regular Visitor
    3 years ago

    Hi,

    without using selectedvalues function is it possible to create summarize table with multi selecteted filter inside Summarize function.

    regards,

    LK