Table with two different formats in the same column. (Accounting (€) + Percentage (%)).wo

Check out this tutorial - You will have to tweak a bit based on your requirements !!

NEW : Dynamic Format String Feature Explained | Add Decimals | Change Currency Symbol | MItutorials (youtube.com)

Hi Robertorufino93 ,

You can create measure for this matrix, here's an example.

As you can see, the last row dispaly the percentage of Group B in the total value is shown.

You can try using HASONEVALUE or ISFILTERED to add to the IF statement that returns values in different formats.

ISFILTERED function (DAX) - DAX | Microsoft Learn

HASONEVALUE function (DAX) - DAX | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.