Forum Discussion

shubham345's avatar
shubham345
Regular Visitor
6 years ago

powerbi

I have net net revenue ,net engagement margin ,client name ,em%(em/nr) by each fiscal year.I need to calculate client count for 80% of em?
Need Help
shubham345's avatar
shubham345
Regular Visitor
6 years ago

Hi Pragati11  fiscal year is in slicer

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi shubham345 ,

     

    I am still not clear on your question. Your sample data seems to be unclear.

    Try sharing sample in a clear way. Headers and rows look mixed up.

     

    Thanks,

    Pragati

    • shubham345's avatar
      shubham345
      Regular Visitor
      6 years ago

      Hi Pragati11 ,

       

      I need to calculate client count,EM,Em% , net revenue for the "80% Em of total"(for top 80%). I have net Engagement margin and client name in the coloumns