Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I would like to fulfil a column with a sumif of values from a different table but with a filter from a slicer.
Let’s give the example:
My objective is, keeping the first list with all items and add one more column to fulfil with the consumption for respective item.
But the consumption must change for the respective year selected on slicer with the year.
For example, if 2021 is selected on slicer, the item, in the first table the item "a" will appear with the value 2 on column consumption, all the other items will keep with no valeu or zero value.
If 2022 was selected on slicer, the item, in the first table the item "a" will appear with the valeu 4 on column consumption and item "c" with 14, all the other items will keep with no valeu or zero value.
Many Thanks
Nuno Paixão
Solved! Go to Solution.
@Anonymous
Hi,
Right click the Item then tick show items with no data.
Please accept this as solution if this helped to solve your problem.
Thank you
Hi Dinesh,
many thanks, so simple.
KR
Nuno Paixão
@Anonymous
First - Create relationship between items table and consumption table base on Item.
Then create a mesure using following DAX formula.
Consumption = SUM(Consumptions[qtd])
Then you will get the answer.
Please post back here if you are having issues.
If this post helped to solve your issue. Please acept as the solution.
Thank you.
Hi Dinesh,
Thanks, but I need keep the other items in the list with zero values.
Many Thanks
Nuno Paixão
@Anonymous
Hi,
Right click the Item then tick show items with no data.
Please accept this as solution if this helped to solve your problem.
Thank you
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
107 | |
101 | |
92 | |
69 |
User | Count |
---|---|
172 | |
135 | |
132 | |
101 | |
95 |