cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.

🙂

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors