Need Help with Power BI Desktop

[Anonymous]

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.

[v-alq-msft · Accepted solution]

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.

[amitchandak]

@Anonymous , A table can not consider slicer value. This means a calculated table can not take slicer value

[Anonymous]

Can we use a measure or a calculated column to control the aggregations based on slicer value?