Issue with slicers and filters

[poniedzielski]

Hello guys,

I have a table with data with the two first columns such like Period (3types) and Market (18) (it gives me 3x18 rows) and several other columns which I wanna to visualize separately (one column - one chart).

What I wanna to do is to have 2 slicers with Period and Market and as a result I want to have a graph based on exactly one row (for specific Period&Market) which I want to visualize.

I made a 2 table with Periods and Markets and made slicer from them, but don't know how to write the measure to return one row from chosen Period and Market from slicer.

I would be very thankful for any advices.

Cheers.

Sample of the two first column.

Up to date	Estonia
Quarter	Poland

Frequent

Spain

[Greg_Deckler · Accepted solution]

You shouldn't have to do any additional work. If you have a measure:

Measure = SUM('Table'[Value])

And you select your market and period from a slicer, then that measure will only display the SUM of "Value" for that period and market.