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.

3 Replies

  • 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?

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