cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Measure with fields from two different tables

I have a mapping table of Assignment group, Owner and Service.

 

Then there are two other tables, Incidents and Requests. These tables contain Assignment group in both.

 

I am doing a count of total Incidents and total Requests and put them into a new table so that i have an overall total but i need to be able to split it by Assignment group. This new table has no relationship as it only has totals of total Incidents +total Requests. I need to be able to click on assignment group slicer and these totals are split.

2 ACCEPTED SOLUTIONS
parry2k
Super User III
Super User III

@Anonymous  I dont think you need to create new table instead create two measures, assuming request and incident table has relationship with mapping table on assignment group

 

Total Incident = COUNTROWS( Incident )

Total Requests = COUNTROWS( Requests )

Now put above measures in a visual like table and put assignment group as slicer, based on slicer, the totals will change

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

@Anonymous that's fine, you can sum up those measure together by creating another measure or do everything in one measure.

 

Total = [Total Incident] + [Total Request]





Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

4 REPLIES 4
parry2k
Super User III
Super User III

@Anonymous  I dont think you need to create new table instead create two measures, assuming request and incident table has relationship with mapping table on assignment group

 

Total Incident = COUNTROWS( Incident )

Total Requests = COUNTROWS( Requests )

Now put above measures in a visual like table and put assignment group as slicer, based on slicer, the totals will change

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Anonymous
Not applicable

But if i wanted to show total = total requests  + total incidents as an overall figure? Then slice it?

 

Yes there is a relationship of assignment group

@Anonymous that's fine, you can sum up those measure together by creating another measure or do everything in one measure.

 

Total = [Total Incident] + [Total Request]





Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Anonymous
Not applicable

Cant believe I made a mountain out of a mole hill.

Very simple way.

Thanks

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

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

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.