Total Value for a calculated dimension

[ishanbansal1204]

Hi Experts,

I have a pivot table where my row is

=IF(DT= 'Response',BU)

Column

=IF(DT= 'Response',SR)

My first measure is

Count(ID)

In the second measure, I am trying to calculate the percentage. Tried with 2 formula but both are not working

COUNT(TOTAL ID)

COUNT(TOTAL <row> ID)

Please help

[Taoufiq_Zarra]

@ishanbansal1204 

Maye be likek :

=num(count(ID)/count(total ID),'#,##0.0%')

or  you can share a sample data and the expected output

[ishanbansal1204]

Not working. 

I have a conditional row so may be thats the problem.

[MayilVahanan · Accepted solution]

Hi @ishanbansal1204 

Try like below

Count(ID)/

COUNT({<DT={ 'Response'}>}TOTAL ID)

[Taoufiq_Zarra]

can you share sample data and the expected output ?

the conditional row formule