topic Re: total trasaction in each age group in DAX Commands and Tips

total trasaction in each age group

Anonymous — Sat, 17 Dec 2022 14:30:11 GMT

I have age in X table and i have amount column in Y table, i have created the age bin in X table.

now i want to calculate total amount in each age bin which function i should use

please do the needful

Re: total trasaction in each age group

Greg_Deckler — Sat, 17 Dec 2022 14:33:36 GMT

Anonymous SUM or SUMX?

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Re: total trasaction in each age group

Anonymous — Sat, 17 Dec 2022 14:47:34 GMT

Age amount

05 20000

16 60000

31 700000

56 400000

66 1000000

30 1200000

26 4500000

20 60000000

17 9000000

i have created age bucket

05-15 20000

16-30

31-55

56-65

66 & Above

now i want to calculate what is the total amount in each age group

Re: total trasaction in each age group

FreemanZ — Sun, 18 Dec 2022 00:28:02 GMT

hi Anonymous

you would need to

1) add a column with this:

AgeGroup =

SWITCH(

TRUE(),

[Age]<=15, "5-15",

[Age]<=30, "16-30",

[Age]<=55, "30-55",

[Age]<=65, "56-65",

"65&Above"

)

2) then plot Amount and AgeGroup columns in a table visual.

I tried and it worked like this:

for the 2) step, you may also choose to create a calculated table like this:

SumTable =

ADDCOLUMNS(

VALUES('Table'[AgeGroup]),

"Amt",

CALCULATE(SUM('Table'[Amt]))

)

Re: total trasaction in each age group

Anonymous — Sun, 18 Dec 2022 14:14:57 GMT

I have one query

there is visual with personal information with filter, how can i create the same

please see the below screen shot

Re: total trasaction in each age group

Anonymous — Sun, 18 Dec 2022 14:32:49 GMT

How can i create shape map with data labels on it like tableau

please refer below screen shot

Re: total trasaction in each age group

Anonymous — Sun, 18 Dec 2022 14:33:39 GMT

this is power bi shape map

Re: total trasaction in each age group

Anonymous — Sun, 18 Dec 2022 14:36:46 GMT

also how can i create shape map with labels on it like in tableau

below is the screen shots for power bi and tableau maps

tableau map

power bi shape map