Forum Discussion
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 !!
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.
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.