Forum Discussion
Anonymous
5 years agoNot applicable
Need Help with Power BI Desktop
Hi Community, Is there a way to control the no of rows considered in Power BI Aggregations based on Slicers selected in the visuals in the front end. Thanks in advance.
- 5 years ago
Hi, Anonymous
Based on your description, i created data to reproduce your scenario. The pbix file is attached in the end.
Table:
Slicer:
You may create a measure like below.
Aggregation Measure = IF( HASONEVALUE(Slicer[Aggregations]), SWITCH( SELECTEDVALUE(Slicer[Aggregations]), "Sum",SUM('Table'[Value]), "Average",AVERAGE('Table'[Value]), "Max",MAX('Table'[Value]), "Min",MIN('Table'[Value]) ) )Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-alq-msft
Community Support
5 years agoHi, Anonymous
Based on your description, i created data to reproduce your scenario. The pbix file is attached in the end.
Table:
Slicer:
You may create a measure like below.
Aggregation Measure =
IF(
HASONEVALUE(Slicer[Aggregations]),
SWITCH(
SELECTEDVALUE(Slicer[Aggregations]),
"Sum",SUM('Table'[Value]),
"Average",AVERAGE('Table'[Value]),
"Max",MAX('Table'[Value]),
"Min",MIN('Table'[Value])
)
)
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.