Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 of members per country. I have the option of adding a calculation within this view in Power Bi. Country Y has X members, i.e. income for country Y is this much? The calculation method is relatively simple. Number of members multiplied by a fixed amount.
Country | Members |
UK | 345 |
GER | 400 |
FR | 500 |
Solved! Go to Solution.
@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.
Proud to be a Super User!
Hi @nuovo2 ,
Create a measure.
income = calculate(distinctcount(member),allexcept(table,country))*number
Best Regards,
Jay
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.
Hi @nuovo2 ,
Create a measure.
income = calculate(distinctcount(member),allexcept(table,country))*number
Best Regards,
Jay
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.
@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.
Proud to be a Super User!
@nuovo2 The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Hallo, vielen Dank für Ihr Feedback. Ich habe bereits zwei Lösungsvorschläge erhalten. Ich bin noch sehr neu und versuche, mich Power BI auf autodidaktischer Basis beizubringen. Ich werde die beiden Lösungen ausprobieren und mich dann mit ihnen in Verbindung setzen. Danke noch einmal.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
98 | |
86 | |
70 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |