How to create restricted key figure in PBI

[Anonymous]

Hi Experts,

I have 3 fields of data coming from my table. I need to calculate the target percentage and display the Tom's percetage in Target % A and Harry's in Target % B columns. The oranged coloured cells should be blank. Can someone please advise how to achieve this.

Thanks

MAHAD

[BurgerToPro]

How about a simple if statement?
If Sales Man = "Tom" then Your function else Blank() -> for cells Target A
If SalesMan = "Harry" then Your function else Blank() -> for cells Target B

[Anonymous]

Thanks for your response.

Can you please let me know how to create the measure in PBI with these conditions. I'm new to Power BI.

Thanks

MAHAD

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

Try measure as below and apply them to table visual：

M_Target Qty A = IF(SELECTEDVALUE('Table'[Sales Man])="Tom", MAX('Table'[Target Qty A]),BLANK())

Target %A = if(ISBLANK('Table'[M_Target Qty A]),BLANK(),MAX('Table'[Sold Qty])/[M_Target Qty A])

M_Target Qty B = IF(SELECTEDVALUE('Table'[Sales Man])="Harry", MAX('Table'[Target Qty B]),BLANK())

Target %B = if(ISBLANK('Table'[M_Target Qty B]),BLANK(),MAX('Table'[Sold Qty])/[M_Target Qty B])

Best Regards,
Community Support Team _ Eason