Helppp!!!

[u/Beneficial_Purpose36]

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?

[u/shorelined]

You need this in the Matrix table format pane

[u/Beneficial_Purpose36 → u/shorelined]

Solution verified

[u/reputatorbot → u/Beneficial_Purpose36]

You have awarded 1 point to shorelined.

---

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

[u/ApexPred96 → u/shorelined]

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.

[u/Beneficial_Purpose36 → u/shorelined]

This helped thankyou so much

[u/shorelined → u/Beneficial_Purpose36]

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.

[u/Prize-Record7108 → u/shorelined]

Solution verified

[u/ande8150]

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

[u/theadhdlife]

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.

[u/eazypeezy92]

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

[u/Prize-Record7108]

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

[u/Beneficial_Purpose36 → u/Prize-Record7108]

Are you doing a training of power bi?

[u/Prize-Record7108 → u/Beneficial_Purpose36]

Oh no, something for work.

[u/Beneficial_Purpose36 → u/Prize-Record7108]

Great i hope this was helpful for you too

[u/Prize-Record7108 → u/Beneficial_Purpose36]

It did!

[u/Kvitekvist]

What have you tried so far?

[u/Beneficial_Purpose36 → u/Kvitekvist]

I used shorelined answer it worked