Forum Discussion
Madhu155154
Helper I
Helper IHow to set Default filter for Matrix or Table
Hi everyone, I want a matrix to show values for a particular filter, L1, from KPI Level by default. Note: I will use KPI Level as a slicer. When I click on the L2 slicer, the table should display...
Hi Based on my understanding, here is my solotion
Approach I used here is -
1. created a new disconnected table with KPI values
2. switched the output based on KPI filters. formula as below:sum of target =SWITCH(TRUE(),SELECTEDVALUE('Table (2)'[KPI Level],"L1")=max('Table (3)'[new kpi]),calculate(sum('Table (2)'[Target]),'Table (2)'[KPI Level]=max('Table (3)'[new kpi])))
if this solves your purpose, please accept this as solution.
ahadkarimi
Solution Specialist
Solution SpecialistMadhu155154create the two measures below, try them out, and let me know if there are any issues.
Filtered_Target =
VAR SelectedKPI = SELECTEDVALUE(Data[KPI Level], "L1")
RETURN
CALCULATE(
SUM(Data[Target]),
Data[KPI Level] = SelectedKPI
)Filtered_Actual =
VAR SelectedKPI = SELECTEDVALUE(Data[KPI Level], "L1")
RETURN
CALCULATE(
SUM(Data[Actual]),
Data[KPI Level] = SelectedKPI
)