Create Table

[MathieuF]

Good morning,
I would like to create a table that will allow me to better display information.
In this table, I would like 4 columns, Indicators, Agent, Team, Skill.
In the Indicators column, the list of my indicators and opposite the value of the indicator of the agent, the team and their skill.
My indicators are measurements that I already have.
How to do ?
THANKS
Mathieu

KPI	Agent	Team	Skill
KPI1	XX (filter agent)	XX (filter Team)	XX (filter Skill)
KPI2	XX (filter agent)	XX (filter Team)	XX (filter Skill)
KPI3	XX (filter agent)	XX (filter Team)	XX (filter Skill)

[Greg_Deckler]

@MathieuF Maybe use a Matrix visual and the "Show values on rows" functionality under I think the Values format card.

Otherwise, Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[MathieuF]

My file is too big and complicated to share.
I put a "Matrix" visual but why don't I have the columns that I indicated in the configuration.

Here's an example I made quickly. https://drive.google.com/file/d/1rIQ_DQlX4stm936jYJABbAXi27cpGkvm/view?usp=share_link

[Greg_Deckler]

@MathieuF So given the sample data provided, what are you desiring to see in the visual? I'm not quite understanding what you want to see in terms of the actual numbers.

[MathieuF]

@Greg_Deckler 

I would like to have 3 columns, Agent, Team, Skill

[Greg_Deckler]

@MathieuF I understand that. But, what are the actual numbers that you want to appear in those columns? Is the Skill for Jack in Group C going to show the number for Jack with Skill XAX or is the Skill column supposed to show the average for the KPI for Jack and Paul in Jack's "row" and Paul's "row"? Or something else entirely?

[MathieuF]

@Greg_Deckler 

I have an "Agent" segment.
I want when I select an agent, I can see in the table the value of their indicator, that of their team and that of their area of expertise.
For example, Pierre is from team A and skill XAX.
So for KPI1, I should have:
Agent: 10
Team: 10
Skill: Avg(10+25): Peter and Paul have the same area of expertise.
I hope that it's clearer.

For information, on my original file I calculate my indicators via a filter FILTER(ALL(team),
team[Agent] = SELECTEDVALUE(Team[Agent])

[Greg_Deckler]

@MathieuF Can't really put my finger on exactly why but this seems super bizarre. Regardless, you solution is in the attached file below signature. Had to do a little data re-modeling and other stuff.

[MathieuF]

Thanks, I'll look at that and get back to you.

[MathieuF]

Hello @Greg_Deckler 
Thank you for your help.
I just realized that the model may not apply, because my measurements are in different bases.
So, I modified the file to best reflect the reality of what I have on the other, larger report.

https://drive.google.com/file/d/1wiBjW7_h5ooVdGG7EIeuzP-iAQie762p/view?usp=sharing

Mathieu

[v-yiruan-msft]

Hi @MathieuF ,

I updated your sample pbix file(see the attachment), please find the details in it.

1. Create a measure as below

Measure = 
SUMX (
    VALUES ( 'KPI'[KPI] ),
    SUMX ( VALUES ( 'Columns'[Column1] ), [Measure to Show] )
)

2. Put the new measure on the matrix visual to replace the original measure [Measure to Show]

Best Regards

[MathieuF · Accepted solution]

Hello,
Thank you very much for the help provided.
I solved my problem using the HTML visual.

[v-yiruan-msft]

Hi @MathieuF ,

It's glad to hear that your problem has been resolved. And thanks for sharing your solution here. Could you please mark your post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours.  Thank you.

Best Regards