cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mamr
Frequent Visitor

Apply grouping to get count of combination between 2 fields

Hi, i have a scenario to apply, which is shown in the screenshoot, and this is my data table in power bi.

How can i acheive this please ?Our needOur needPower BI Data TablePower BI Data Table

3 REPLIES 3
v-yingjl
Community Support
Community Support

Hi @Mamr ,

Based on your Data Table in power bi, not certain what is your expected output, what's the relationship between the data table and your needed picuture? Could you please consider sharing more details about this issue like your expected output based on the data table in power bi etc. for further discussion?

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Jimmy801
Super User III
Super User III

Hello @Mamr 

 

add first a new column to your data with this formula to create a key for you columns

[Incident Type]&"-"&[Order Type]

 

Then use a matrix-visual to count the rows

Jimmy801_0-1605595384526.png

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

 

HotChilli
Super User II
Super User II

I don't think anyone's going to be able to work this out without an explanation please.

There are extra data fields in the result and I can't see anything doing this -> "Apply grouping to get count of combination between 2 fields"

 

Also, please post data instead of a picture

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors