Filter by measure

[Marcin]

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 

[v-sihou-msft · Accepted solution]

@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]

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 😞 

[Marcin]

That woorks, thank's a lot for help.