Cannot Create Measure : Cannot find table

[lordluis2000]

Hi, 

On th eimage I tryed to create a measure but the DAX does not find any table in the list. So any time I try to make a reference does not work.

I did try to rename the table, create another table related with the original. But anything work 😞 

I am using a SQL Server with Direct Query and those tables are created using Merge function.

Any Clue ?

LM

[dobregon · Accepted solution]

I'm not 100%sure but if you create a measure with an IF, the conditions in the if should be measures, for that reason you only see one measure that it is your measure claled "recuento.. etc"

In your case, you can create the column with that conditions and then do a measure about the sum or something.

Or you can create the a sumx with some conditions if you one to count something

[lordluis2000]

Very Interesting

Well, I very new on this of PowerBI and I dod not know about this limitation. I will do it as you say.

Thanks 

LM 

[dobregon]

other example, assuming that you are count the values that match with other column with 1. you can do something like this

MEASURE = CALCULATE (COUNT(table[column to count]), FILTER(TABLE, TABLE[yourcolumnfilter]=1))