- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Group results into a single field within a matrix
Hello everyone,
Hope you all have a grear day!!!!
I have this issue:
I have this matrix:
And, I need to create this. Where the values of "PerDifAtendPersOtros" are added or summarized on the new field project "Otros Proyectos"
Projects is a column in a table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Remember that you compute the matrix measure four times, including for the column totals and the row totals. You can also rename "Total", in your case to Otros Proyectos.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @lbendlin thanks for helping me.
Sorry, I don't understand what you mean. I have two measures "PerDifAtendPers" and "PerDifAtendPersOtros". I don't refer to put the total column or row .
The thing is, the matrix has to show the current projects, those are shown crossing "PerDifAtendPers" with the field "Project" as a rows. And, the projects up to last year should be added up and summarized as "other projects" ("Otros Proyectos") as if it were another projects, this is calculated by "PerDifAtendPersOtros"
Is there a way to automate other projects in a single group?
***************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @lbendlin
Thank you very much for your help.
I've just sent you a private message with a link where you can download the data
🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Here is the general approach. You re-appropriate the Totals section to display the value for "otros"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @lbendlin
It could work but now I have levels in the rows. So, the total would not have its level
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @lbendlin
This is the table expanded how it should looks like, the next level is "IDSolicitante". The main point is to watch the project and the people involve in it.
In a private message I sent you a link to access the data
Is there a way like using issubtotal with rollup and with that summarize all in "Otros Proyectos" assigning this name to this new field?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Your AccionesIPI table is missing the event name . You know that someone attended via a certain medium, but you don't know which event they attended.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I don't understand @lbendlin
The table can be related by Proyecto[Participantes.IDSolicitante] and AccionesIPI[IDSolicitante]. And the condition is only to count the rows with medio as "Presencial" or "Blank"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

So the same person attending multiple events will have different IDs?
What should happen when the attendance date is outside the event date range?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello!
No, there is only one ID per person. And, one person can attend different projects at the same time.
The number 1 is to count if the person attended or not.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
09-05-2024 01:50 PM | |||
11-14-2024 06:33 AM | |||
08-12-2024 04:31 AM | |||
11-18-2024 10:43 PM | |||
07-13-2024 09:54 AM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |