how to create a measure to report a certain value filtered

[Anonymous]

I need to create an object to report the year I have filtered, but not how to do this by the language fit DAX used by Power BI and even if it is possible to do this.

For example, a card-type object displaying the filtered year at that time

[Greg_Deckler · Accepted solution]

Assuming you have a column called "Year" that has the years, add that as a slicer.

Create a measure with the following formula:

CurrentYear = MIN([Year])

Add that measure in a card visualization.

[Sean]

@Anonymous you are implying you will use a slicer (or another visualization) to filter the Year

if so there's no need to change the measure or inlcude the filter in the measure

When you select a Year in the Slicer - the Card will only show that Year's total - if no Year is Selected - total for all years

Let me know if this helps!

[Greg_Deckler · Accepted solution]

Assuming you have a column called "Year" that has the years, add that as a slicer.

Create a measure with the following formula:

CurrentYear = MIN([Year])

Add that measure in a card visualization.

[Anonymous]

@Greg_Deckler

The Min function serves as the data type is a number but and when a text, varchar for example?

[sornavoor]

If this is single select only  Try These: 

Displayed Text With Year  = IF ( ISFILTERED(<Year Table - Column>, CONCATENATE("Report Page is Filtered for Year Value of ", (IF(HASONEVALUE(<Year Table - Column>), FIRSTNONBLANK(<Year Table - Column>,"") ,""))), "Report Page is not Filtered by Year")

Alternative  simple one without Text Concatenation: 

Year Selected = IF(HASONEVALUE(<Year Table - Column>), FIRSTNONBLANK(<Year Table - Column>,"") ,"")

[Sean · Accepted solution]

@Anonymous you actually wanted to display the filter Year itself okay

but that will only work with 1 year at a time

only way I think you can do this with text filters is with the function VALUES( )

Current Text Filter = VALUES([Text Column Filter])

AGAIN just as with the year this will only work for 1 filter at a time!

This is what I mean (you've selected more years but card only shows 1)

[Sean]

@Anonymous If you want add this to your Measure (came across to it today)

Current Text Filter = IF ( HASONEVALUE(TableName[Column Name]), VALUES(TableName[Column Name], "Multiple Selections")

Look at the picture