cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Resolver I

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

12 REPLIES 12
Super User

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.

Resolver I

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])
)

Super User

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.

Resolver I

Thank you very much for your help.

I've just sent you a private message with a link where you can download the data

🙂

Super User

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

Resolver I

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

Super User

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

Resolver I

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?

Super User

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.

Resolver I

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"

Super User

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

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

Resolver I

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.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors