Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Antonio_Gomez
Resolver I
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:

Antonio_Gomez_0-1694094269473.png

 

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

 

 

Antonio_Gomez_1-1694094315800.png

 

12 REPLIES 12
lbendlin
Super User
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.

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

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

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

 

🙂

 

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

 

lbendlin_0-1694523444018.png

 

Hi @lbendlin 

 

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

 

Antonio_Gomez_0-1694525662852.png

 

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

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?

 

 

Antonio_Gomez_1-1694527318283.png

 

 

 

 

 

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.

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"

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

 

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

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

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.