The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Hi,
without using selectedvalues function is it possible to create summarize table with multi selecteted filter inside Summarize function.
regards,
LK
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 , 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]) ) )
User | Count |
---|---|
82 | |
81 | |
37 | |
34 | |
31 |
User | Count |
---|---|
94 | |
80 | |
60 | |
50 | |
49 |