Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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.
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    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.

amitchandak's avatar
amitchandak
Super User
5 years ago

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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