How to display number and percent both both in row in table

[mdaamirkhan]

Hi All,

I need help on below table I want replicate this in power bi but how.  How to display this  below table in power  bi number and percent both in one table in rows. 

If you can help me it will be greate . if you can share the pbix file how its done what will be logic

How to display this table in power number and percent both in one table in rows

[speedramps · Accepted solution]

Create a measure for each value like this 

Product = DISTINTCOUNT(Facts[product])

[Staff Salary] = SUM(Facts[salary])
[Sales%] = DIVIDE( SUM(Facts[sales], [Total sales])

Then create table calledDriver like this

ID, Type
1,"Product"
2,"% Product"
3,"Product 2"
4,"% Product 2"

5,"Staff Salary"
6,"Sales %"

Sort the Type by ID

Then create a measure like this

KPIS =
SWITCH(SELECTEDVALUE(Driver[Type]),

"Product",[Product],
"% Product"",[Product%],
3,"Product 2",[Product2],
4,"% Product 2",[Product2%],

5,"Staff Salary",[Staff Salary],
6,"Sales %",[Sales%],
)

Drag table visual to your report canvas with

Driver[Type] and KPIS 

You will then nees to Format command the %.

See https://docs.microsoft.com/en-us/dax/format-function-dax

Thanks for reaching out for help.

I have helped you, now please help me by giving kudos.

Remeber we are unpaid volunteers and here to coach you with Power BI and DAX skills, not do users job for them !

So plaase click the thumbs up and accept as solution button. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !