Forum Discussion

vaishalisah's avatar
vaishalisah
Regular Visitor
9 years ago

Can we use measure in visual filter in DirectQuery Mode?

Hello,   I want to filter data for the current month. I have created a measure to tell me how many months old the record is. When I try to use that measure in Visual filter, its fields are disabled...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

vaishalisah

 

It should work, did you put number under "is less than" filter?

 

 

Regards,

vaishalisah's avatar
vaishalisah
Regular Visitor
9 years ago

Hello Anonymous, v-sihou-msft

 

Thank you for your reply.

Following is the measure I created:

 

Months Old = DATEDIFF(MAX('Values'[ValueDateTime]),TODAY(),MONTH)

 

It doesn't allow me to filter by the measure, unless I add its base Column "ValueDateTime" in the visualization.

And, I cannot apply page level filter at all using measure. 

 

 

 Is adding calculated column the way out?

Regards,

Vaishali