Userprinciplename () to filter value only visuals

[Anonymous]

Hi, 

I have some visuals that only contain values from the facts table and I would to filter this by userprinciplename, so people only see their values. I tried to make a measure that countrows  fact table but it is not possible to add the measure to the visual filter.

suggestions?

[amitchandak]

@Anonymous ,

countrows(filter(Table, Table[email] =userprinciplename() ) )

Also check RLS

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk

[Anonymous]

How would countrows measure affect the filtering of the values when it is not possible to put the measure as countrows > 0  in the visual filter 

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

You can create a new measure 'M_value' to replace the field 'Value'.

M_countrows =
COUNTROWS ( FILTER ( 'Table', 'Table'[Email] = USERPRINCIPALNAME () ) )

M_Value =
CALCULATE (
    SUM ( 'Table'[Value] ),
    FILTER ( 'Table', 'Table'[M_countrows] >0 )
)

Best Regards,
Community Support Team _ Eason