Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Table cannot be used in Computations

I have received the following error after attempting to produce a date at which the forecasted points reach the estimated points in the calculated table.

==>

My table is shown below. I have tried to go around the problem by indicating whether the conditions are met by displaying a "1." 

At the top right, I am attempting to only show the first date in which those conditions are met but can't seem to get the visual to only show the intercepting date. In fact that visual has just been scrolled to show an example of what I hope to produce.

Here is the line of DAX that is giving me trouble because this entire table is built on measures, rather than from the source table. 

How can I go about only showing that single date in a card so that we won't have to force people to scroll down to the first 1 in the particular column they are looking at?

 

Thank you in advance.

 

2 Replies