Columns are a DAX measure for percentages. Require an actual figure in total (not percentage

[KarenFingerhut]

Hi there

I hope someone can help me please.

I've created a table and added a column to show percentages against categories, example below.

The %'s are being created in DAX. SUM(Column A in dataset PLUS Column B in dataset) DIVIDED by column A. This gives me a % figure. However in the overall total row at the bottom I want the actual figure. So, SUM Column A PLUS Column B.

Is that actually doable please. I'm really struggling with this one

Many thanks 

Karen

Category	2025 %'s
1	25%
2	10%
3	50%
4	32%
5	98%
Total	78 Sum of the actual figures

[KarenFingerhut]

Thanks so much for getting back to me @Ashish_Mathur  and @Jihwan_Kim  The ISINSCOPE worked a treat. Everyday is a school day 😀

Kind regards

Karen

[Ashish_Mathur]

Hi,

I have solved it with dynamic format strings.  File attached.

Hope this helps.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below.

ISINSCOPE function (DAX) - DAX | Microsoft Learn

Expected result: =
IF (
    ISINSCOPE ( Data[Category] ),
    FORMAT (
        DIVIDE ( SUM ( Data[A] ) + SUM ( Data[B] ), SUM ( Data[A] ) ),
        "#.00%"
    ),
    SUM ( Data[A] ) + SUM ( Data[B] )
)