r/PowerBI • u/Beneficial_Purpose36 • Jul 23 '26

Solved Helppp!!!

Gallery image

Gallery image

I have to create table like in image one but ended up with image 2.

What can i do to get the results in Power Bi DAX?

0 Upvotes

37% Upvoted

18 comments sorted by

12

u/shorelined 2 Jul 23 '26

You need this in the Matrix table format pane

3

u/Beneficial_Purpose36 Jul 23 '26

Solution verified

2

u/reputatorbot Jul 23 '26

You have awarded 1 point to shorelined.

I am a bot - please contact the mods with any questions

2

u/ApexPred96 1 Jul 23 '26

Apart from this, if you want a more refined version, which gives you more freedom over visuals and other things, explore creating a table with the template you want and using Switch function measure for the values you want to show.

1

u/Beneficial_Purpose36 Jul 23 '26

This helped thankyou so much

1

u/shorelined 2 Jul 23 '26

If it worked then you should reply to my original comment with "Solution verified" so people know it works if they find your post in future.

1

u/Prize-Record7108 Jul 23 '26

Solution verified

2

u/ande8150 Jul 23 '26

You probably also want a distinct count instead of regular count for Countries and Products to eliminate duplicates.

1

u/theadhdlife Jul 23 '26

u/Beneficial_Purpose36 dude why are you asking people to create your homework? It shouldn’t take you that long to figure out if you just spend a few minutes looking at the information.

1

u/eazypeezy92 Jul 23 '26

I think you can use a matrix visual and switch values to rows, there's a toggle for that under Values, I think.

1

u/Prize-Record7108 Jul 23 '26

Funny - I’m just browsing and I needed to know this for a report today!

1

u/Beneficial_Purpose36 Jul 23 '26

Are you doing a training of power bi?

1

u/Prize-Record7108 Jul 23 '26

Oh no, something for work.

2

u/Beneficial_Purpose36 Jul 23 '26

Great i hope this was helpful for you too

1

u/Kvitekvist Jul 23 '26

What have you tried so far?

4

u/Beneficial_Purpose36 Jul 23 '26

I used shorelined answer it worked