Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi ,
I am new at Power BI , and I am stuck at creating a new bridge table which is dynamic from other master table with filter.
I have a table ""structure"like below
bag# , item# qty
Apple A 1
Apple B 2
Orange A 3
I want to create a new table to list the unique value of " bag#" , and a sum qty , and it is dynamic when I filter by Item# from the "structure" table,
for example ,
if I filter item#= A ,I want to get below in new Table
Bag# qty
Apple 1
Orange 3
I used : summarize(Structure, structure[bag#],"qty",caculate(sum(structure[qty]),allexcept(structure,structure[Item#])))
but it does not return correct qty .
anyone can help ,please ?
thanks a lot
Eric
Hi @erche3,
Why do you want to make a summarize table? Depending on the visual you want you can create measure or add filters/Slicers to your reports that allow you to have the expectd quantites since the calculations are made based on context.
When you create a new table and considering you are using the summarize the resul of the full table will be the sum of all rows in this case 3 for each bag#.
You can use the summarize function to use in a measure that will then calculate the value you need.
Can you please add some addtional information about the expected result.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi ,
You can import an attribute slicer from market place and drag Item into it. It will give the desired result.
You can remove Item too as below :
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |