Forum Discussion

Mrignalini's avatar
Mrignalini
Frequent Visitor
1 year ago
Solved

Why AllSelected function in used with filter function for average calculation per category

here as you can see for calculating the average per project name, AllSelect is used. Also why Max() is used here.

Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago
    • ALLSELECTED: It ensures that only the selected Project rows are considered when calculating the average, while ignoring the current row context in the visual.
    • MAX(Project[Project Name]): MAX is used to get the value of the Project Name in the current row of the table or visual.

1 Reply

  • Kedar_Pande's avatar
    Kedar_Pande
    Super User
    1 year ago
    • ALLSELECTED: It ensures that only the selected Project rows are considered when calculating the average, while ignoring the current row context in the visual.
    • MAX(Project[Project Name]): MAX is used to get the value of the Project Name in the current row of the table or visual.