Forum Discussion

nuovo2's avatar
nuovo2
Regular Visitor
5 years ago
Solved

Measures

Hello  I have about 10,000 member names and their country affiliation in an Excel spreadsheet. I imported this table into PowerBi Desktop and created a report. One of the reports shows me the number...
  • negi007's avatar
    5 years ago

    nuovo2 What i understand from this, you have a table which has list of all 10K memebrs and their country name. You wish to calculate total income for each country (Total Members * Income). So in this case, you can have second table where you will have country name and the income then you can link first and second table on the country name and do the calculation.

     

    Total Income= count(members) * sum(income)

     

    Please let us know if you wish to have something else. 

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi nuovo2 ,

     

    Create a measure.

    income = calculate(distinctcount(member),allexcept(table,country))*number

     

    Best Regards,

    Jay

  • nuovo2's avatar
    nuovo2
    5 years ago

    Although I am new, I have also been able to implement your solution with success. I just want to add the thousands separator plus the euro symbol.