How to Show Value and Global Percentage in Card

[Anonymous]

I would like to show a field count value and % of Global Count on same card. Something like this. How can we do that ?

[Anonymous · Accepted solution]

Hi @Anonymous ,

Take a look at CONCATENATE() function in Power BI.

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

The CONCATENATE() function in DAX accepts only two arguments. If you need to concatenate multiple columns, you can create a series of calculations or, better, use the concatenation operator (&) to join all of them in a simpler expression.

Something like below.

Measure 4 = CONCATENATE(CONCATENATE([Measure],CONCATENATE(" (",[Measure 2])),")")

Measure 3 = [Measure]&" ("&[Measure 2]&")"

 

Best Regards,

Jay

[Fowmy]

@Anonymous 

You combine the two measures as below, suppose you have the count in _Count Measure and % in _Percent measures.

New Measure =  _Count & " ("&FORMAT(_Percent,"0.0%")& ")"

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn