CODEWITHSUNDEEP
powerbidax
Afiq Johari
Afiq Johari

Reputation: 1462

DAX Power BI: Respect the individual format of each measure during concatenation

I have 2 measures that I want to concatenate while respecting their original format. The last column should be % ticket type (numberDistinctCount).

For example 59.83% (168,479) but instead when I combine them both, it appears that the formatting was lost and becomes 0.598337950138504 (168479)

The definition I use for the last column is

% count ticket type = [% ticket type] & " (" & [numberDistinctCount] & ")"

enter image description here

Is there a way to ensure that the concatenation of 2 measures respect the individual measure format?

The result of this concatenation will be used as a tooltip

Thanks

Upvotes: 1

Views: 901

Answers (1)

Marcus
Marcus

Reputation: 4005

You have to wrap your measures in FORMAT functions for this, else Power BI just defaults to the numerical output from your measure - in this case a decimal that is "primed" for percentage formatting.

Try this:

% count ticket type = 
FORMAT ( [% ticket type] , "0.00%" ) & " (" & [numberDistinctCount] & ")"

Upvotes: 1

Related Questions