Group results into a single field within a matrix

[Antonio_Gomez]

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

[lbendlin]

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.

[Antonio_Gomez]

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?

***************

PerDifAtendPers = CALCULATE(

DISTINCTCOUNT(AccionesIPI[IDSolicitante]),

FILTER(

AccionesIPI,

OR(

AccionesIPI[Medio] = "Presencial",

AccionesIPI[Medio] = BLANK()

)

),

FILTER(

Proyectos,

YEAR(Proyectos[Inicio]) = SELECTEDVALUE('Calendario Base'[Año]) || YEAR(Proyectos[Fin]) = SELECTEDVALUE('Calendario Base'[Año])

),

USERELATIONSHIP('Calendario Base'[Dia],AccionesIPI[Fecha])

)

******************************

PerDifAtendPersOtros = CALCULATE(

DISTINCTCOUNT(AccionesIPI[IDSolicitante]),

FILTER(

AccionesIPI,

OR(

AccionesIPI[Medio] = "Presencial",

AccionesIPI[Medio] = BLANK()

)

),

FILTER(

Proyectos,

YEAR(Proyectos[Fin]) <> SELECTEDVALUE('Calendario Base'[Año])

),

USERELATIONSHIP('Calendario Base'[Dia],AccionesIPI[Fecha])

)

[lbendlin]

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...

[Antonio_Gomez]

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

🙂

[lbendlin]

Here is the general approach.  You re-appropriate the Totals section to display the value for "otros" 

[Antonio_Gomez]

Hi @lbendlin 

It could work but now I have levels in the rows. So, the total would not have its level

[lbendlin]

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

[Antonio_Gomez]

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?

[lbendlin]

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.

[Antonio_Gomez]

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"

[lbendlin]

So the same person attending multiple events will have different IDs?

What should happen when the attendance date is outside the event date range?

[Antonio_Gomez]

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.