Inline table in the query editor for drop down static list:
Scenario_Comp_Filter:
Load * inline [
MID,Measure
1,"Sales"
2,Percentage
];
Dropdown selected values in the aggreegate.
If(GetSelectedCount(Measure)=0,Num(Sum([Sales]),'#,##0'),
Pick(Match(MID,'1','2'),
Num(Sum([Sales]),'#0.00%'),
Num(Sum(Percentage),'#,##0'),
//Num(Sum([Sales]),'$###,##0'),
))
Use below expression in Show condition of the field.
If(GetSelectedCount([Level 1]) > 0 ,$(=SubStringCount(Concat([Level 1],'|'),'Field1')),0)
No comments:
Post a Comment