Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

dax help

 - hi ,       I need count of my bidc column where "all units usa" measure is greater than 10.       I am not able to write measure inside a calculate function as filter.       =Calculate(count(da...
DAX
DAX Calculation
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

You can't use a measure inside a boolean expression that is used as filter expression. There are certain rules related to this

 Refer to this: https://docs.microsoft.com/en-us/dax/calculate-function-dax

Apart from this your measure [usa sku count] =  calculate(count(product[sku]), [all units usa] >1) doesn't refer any column which needs to be filtered.

 

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

hi, i understand those rules about calculate function..but i am looking for a help or work around.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous can you share some sample data along with expected output and a clear description of the problem. Maybe then I can help you.

     

    Thanks