Custom column (Recent Date) not working as filter in visual

[Anonymous]

hi All,

I am working on my first Power BI report. 

Requirement is pretty simple. 

I have to visual the data for the latest(MAX) date from the table. 

Steps I followed:

1. Created a new column  MaxReportDate= MAX('table_1'[ReportDate]). This gives me maximum date in the data set. 

2. Now in visual, i pull the rest of the data and put this maxReportDate in filter. But nothing happens. the data is not filtered by this column. 

3. How ever, If I pull all the report dates in the visual and then click on recent date, it works. 

4. I also tried creating another column with below query

MaxReportDateFlag = VAR LatestDate =

CALCULATE ( MAX ( 'table_1'[ReportDate]), ALL ( 'table_1' ) )

RETURN

IF ( MIN( 'table_1'[ReportDate] ) = LatestDate, 1, 0 )

5. This calculation is retruning only 0 and not 1 for the max date. 

5. What is it that I am missing ?

Any help is appreciated!

[v-cherch-msft]

Hi @Anonymous 

You may create a measure with your formula instead of column.Below are some articles about column and measure for your reference.

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

https://www.blue-granite.com/blog/understanding-the-differences-between-calculated-columns-measures-in-power-bi

Regards,

[Anonymous]

thank you very much..

I have two questions :

1. when we create measure, why is it not seen in data pane (where all columns are seen)?

2.  I cannot drag this measure under report/page level filter to look for only 1. I have to bring in date and this measure in the visual then filter by 1. I would like to hide this measure from the visual. 

is there a way to do this? 

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

---

1. when we create measure, why is it not seen in data pane (where all columns are seen)?

---

Measure is different with column.Column could be seen in data table.Measure could be changed with different context in visual.It could be used in visual to get dynamic value.For further,please have a look at below articles to understand it.

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

https://www.blue-granite.com/blog/understanding-the-differences-between-calculated-columns-measures-...

---

2.  I cannot drag this measure under report/page level filter to look for only 1. I have to bring in date and this measure in the visual then filter by 1. I would like to hide this measure from the visual. 

is there a way to do this? 

---

You may drag it to visual level filter and set it as 1.

Regards,