Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I need your help. I have a table with a notion of parent and child (Region / Department / City). When we select a parent entity, I would like to display a table with the detail of the indicators for the child entities but also the values for the parent entity. For child entities, it works well but not for parents.
Here is what I did but it returns an empty value:
Thank's for your help
Solved! Go to Solution.
Hi @Anonymous ,
I'm not totally sure this is what you're after. Hopefully I've interpreted your question correctly.
It looks to me like in your sample data the total of VALEUR for the children don't add up to the VALEUR for the parent. I guess that's the issue you're trying to solve? Just using SUM(NEW_TABLE[VALEUR]) in the matrix would result in the sum of the children's value being displayed for the parent.
Here's a measure to give the parent's amount for parent rows and children's amount for children.
Hi @Anonymous ,
I'm not totally sure this is what you're after. Hopefully I've interpreted your question correctly.
It looks to me like in your sample data the total of VALEUR for the children don't add up to the VALEUR for the parent. I guess that's the issue you're trying to solve? Just using SUM(NEW_TABLE[VALEUR]) in the matrix would result in the sum of the children's value being displayed for the parent.
Here's a measure to give the parent's amount for parent rows and children's amount for children.
Hi @PaulOlding
Thank's so much it seems to work 🙂
However, I will need to use this measure to create several measures. (I want to create metrics for some values in the co_indic column) but my new metric doesn't seem to work.
I want to have a table like this but I want to put the names of the indicators in place of their codes and not display the Total row (last row of the table).
Thanks
@Anonymous
Can't you put CO_INDIC in the Column field well of a matrix visual? No need to have separate measures then.
You mention wanting a description rather than the code. If you don't have that in your model you could add it as an extra table. A table with 2 columns: CO_INDIC, DESCRIPTION that has one row per CO_INDIC. Create a relationship between this and NEW_TABLE on CO_INDIC.
If you really want to have searate measures then try this syntax:
User | Count |
---|---|
57 | |
33 | |
18 | |
18 | |
15 |
User | Count |
---|---|
94 | |
86 | |
39 | |
22 | |
20 |