Forum Discussion

Marcin's avatar
Marcin
Helper V
9 years ago
Solved

Filter by measure

Hi,   I need to build report in Direct Query Connection with Analysis Services on Azure Cloud. In this report I need to filter existing measure Hours ( from timsheet ) for each user that is using t...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    Marcin

     

    I think you can add a tag measure like:

     

    Tag = IF(MAX(Users[Email])=LOWER(USERNAME()),1,0)

     

    Then use above measure in visual level filter.

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

Marcin

 

I think you can add a tag measure like:

 

Tag = IF(MAX(Users[Email])=LOWER(USERNAME()),1,0)

 

Then use above measure in visual level filter.

 

Regards,

Marcin's avatar
Marcin
Helper V
9 years ago

That woorks, thank's a lot for help.