Convert Measure to Table Column

[rcarle]

I've got the following measure that works great.  My problem is that I can't use it as a filter on this page becasue of PBI limitations.  I also can't add this measure as a filter to the visual called Tachometer, not sure why.  As a result, I need to convert this measure to a table column, so that I can apply the filter to this page which does work with the Tachometer.  The measure is as follows:

When I convert this to a table, I have to filter the data by project number, so that it aggregates by project, since each project has multiple rows of data.

The problem is that the new column is not recognizing the date filter on the page like the measure does, so I'm get totals that reflect all dates instead of what's set on the page.  Any thougths?

[rcarle]

Thanks @davehus.  I agree that what I'm trying to do works best as a measure, but I'm trying to find a workaround to the real problem which is PBI will not allow me to set a measure as a filter to the page.  I thought I could just apply the measure as a filter to each visual on the page, but I can't apply it to the tachometer for some reason. 

[davehus]

Hi @rcarle , A calculated column refreshes only once, it does not respond to filtering in the same way a measure does. See this link for more info. 

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/#:~:text=A%20measure%20is%20ev....

Hope this helps

Did I help you today? Please accept my solution and hit the Kudos button.