Forum Discussion

nsingh07's avatar
nsingh07
Icon for Helper I rankHelper I
5 years ago

Urgent help needed - Dynamic weighted averages based on multiple filter selections

Hi,   Need help in getting the logic for calculating the weighted average by Revenue at different aggregtion level. The weighted average should be dynamic based on the permutation & combinations th...
Need Help
nsingh07's avatar
nsingh07
Icon for Helper I rankHelper I
5 years ago

FYI, I'm new to Power BI hence a detailed post would be very helpful.

Thanks.

 

Ashish_Mathur tagging you since saw few of your post on this topic.

 

MattAllington 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

I have read your question a few times over but just cannot understand what you want.

  • nsingh07's avatar
    nsingh07
    Icon for Helper I rankHelper I
    5 years ago

    Ashish_Mathur 

    I need help indefining a logic / DAX to calculate the weighted average score at different aggregation level (1/2/3) dynamically based on the filter selection

    • nsingh07's avatar
      nsingh07
      Icon for Helper I rankHelper I
      5 years ago

      Can someone please share the logic for calculating weighted average based on slicer selection

      TIA