Hi friends,
Hope someone can assist me please.
I'm currently using three visuals in PowerBI:
1. A bar chart for different currencies and corresponding volume (eg. AUD, EUR. GBP etc.)
2. A card with a gross volume amount - Measure: Gross = CALCULATE(SUM(Bulking[Gross]),Bulking[Count] = 1)+0
3. A card with a net volume amount - Measure: Net = CALCULATE(SUM(Bulking[Net]),Bulking[Count] = 1)+0
I also have two Tables:
- A "Currency" table with the below columns (for the bar chart):
A: Date
B: Currencies
C: Volume Amount
- A "Bulking" table with the below columns (for the Cards):
A: Date
B: Currency (A currency is listed here if there is a netting opportunity, otherwise the cell is blank)
C: Gross Volume Amount (currency gross amount is listed here if there is a netting opportunity, otherwise the cell is blank)
😧 Net Volume Amount (currency netamount is listed here if there is a netting opportunity, otherwise the cell is blank)
E: Count (number 1 if there is a netting opportunity, otherwise the cell is blank)
I have a Slicer that filters by Year and Month. The Slicer works as intended for the page, meaning that when I select a month and year, if filters the Currency bar chart and the two Cards correctly as expected.
The problem happens after I select a year/month, and then try to filter further by selecting a specific Currency from the bar chart. I would expect the cards to filter down to the next level as well and give me the gross/net amounts for that specific Currency, but instead they remain unchanged.
What am I missing here? I tried to change the relationships but was unsucessful, but truthfully I'm not really sure what the relationships should be. Is there a dax option I could try out instead?
Thanks in advance.
