Forum Discussion

Marcin's avatar
Marcin
Icon for Helper V rankHelper 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 this report. ( RLS in SSAS is not posssible in this case ).

I made an idea to do that with new measure ( now its possible to use measures in Direct Query ) and 

Users[Email]))=LOWER(USERNAME(). 

But I need help to do that in DAX Measure for this report, I will be gratefull for help with this case 

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,

3 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft 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
      Icon for Helper V rankHelper V
      9 years ago

      That woorks, thank's a lot for help. 

    • Marcin's avatar
      Marcin
      Icon for Helper V rankHelper V
      9 years ago

      Hi,

       

      I have a question, the measure works correctly, but the problem is when I publish any report containing this measure on Power BI serivce , tile's data are not refreshing dispite Live Connection to SSAS Tabular Model. Even when I clicki refresh button 

       

      In this case when I want to show fresh data with my tiles a need to download pbx file to my computer, click refresh and publish it again :(