Direct query mode logics

[Rockz]

Dear champions,

Can anyone please suggest me whether it is possible to use parameters in slicer to filter the data in  direct query mode? Because am not am able to achieve it.

and also one more thing could anyone please let us know how business hours logic works in direct query mode?

thanks in. Advance 

[amitchandak · Accepted solution]

@Rockz , You need to consider the dynamic m parameter

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

https://blog.crossjoin.co.uk/2020/10/25/why-im-excited-about-dynamic-m-parameters-in-power-bi/

Use this but inside Sumx or averagex

https://exceleratorbi.com.au/calculating-business-hours-using-dax/

Example

Sumx(Table, <Business hour logic using columns>)