How do you change the tables in chart filters

0 votes

I am working on a report that shows 3 different figures and a bar chart with some slicers 

The Table is shown below

A B C D

A1

1 9 20

A2

2 8 20

A3

3 7 20

Measure 1 - C/D 

Measure 2 - Calculate( Measure 1, AllExcept('Year'))

Measure 3 - Calculate( Measure 1, AllExcept('B'))

And the Bar Chart has  X Axis - B , (Drilldown A) 

Y Axis - Measure 1

If I use slicers the figures are changed correctly but if I select the bar chart, Measure 2 does not show the correct number 

How do you make Measure 2 to be able to change based on the chart 

May 10, 2019 in Power BI by Phalguni
• 1,020 points
606 views

1 answer to this question.

0 votes

Hi,

You can use the following measure.

Measure 2 = CALCULATE ( [Measure 1], FILTER ( Table, Table[Year] = MAX ( Table[Year] ) ) )
This can be done with the help of DAX in power BI
answered May 10, 2019 by Avantika
• 1,520 points

Related Questions In Power BI

0 votes
0 answers

How do you handle complex relationship-based calculations when multiple tables are involved in a DAX query?

How do you handle complex relationship-based calculations ...READ MORE

4 days ago in Power BI by Evanjalin
• 2,560 points
22 views
0 votes
0 answers
0 votes
0 answers

How do you handle complex relationship-based calculations when multiple tables are involved in a DAX query?

How do you handle complex relationship-based calculations ...READ MORE

2 days ago in Power BI by Evanjalin
• 2,560 points
20 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,350 points
1,214 views
0 votes
1 answer

How do I use Python scripts in Power BI?

Hi, You can create interactive reports out of ...READ MORE

answered May 2, 2019 in Power BI by Avantika
• 1,520 points
2,399 views
0 votes
1 answer

How To use R Integration in Power BI?

Hi,  There are a lot of packages available ...READ MORE

answered May 3, 2019 in Power BI by Avantika
• 1,520 points
2,605 views
0 votes
0 answers

How do you change the tables in chart filters?

I am working on a report that shows ...READ MORE

May 10, 2019 in Power BI by anonymous
619 views
0 votes
1 answer

How do I create a line chart?

Hi, From the data mentioned above, you can ...READ MORE

answered May 10, 2019 in Power BI by Avantika
• 1,520 points
686 views
0 votes
1 answer

How do you create a link visual in Power BI?

You can easily create a link between ...READ MORE

answered Mar 9, 2019 in Power BI by Avantika
• 1,520 points

edited Mar 9, 2019 by Avantika 5,094 views
0 votes
1 answer

How do you use R visuals in Power BI Desktop?

Hi, In order to use R Visuals you ...READ MORE

answered Apr 10, 2019 in Power BI by Avantika
• 1,520 points
662 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP