Calculated Percentage Field is appearing twice

[abeenish]

I am using a DAX Measurement to calculate the (#In program) / (# Referred).  I ge the correct % but what do I do so that the % column only appears once and to end of the table.

DAX:

% Difference = DIVIDE ( 

CALCULATE ( COUNT ( FactClientTransactionsProgram[status] ), FactClientTransactionsProgram[status] = "In Program" ),

CALCULATE ( COUNT ( FactClientTransactionsProgram[status] ), FactClientTransactionsProgram[status] = "Referred" ))

[v-zhangti · Accepted solution]

Hi, @abeenish 

You can try the following methods.

Measure:

In Program Count of status = 
CALCULATE(COUNT (FactClientTransactionsProgram[status]),FactClientTransactionsProgram[status]="In Program" )

Referred Count of status = 
CALCULATE(COUNT(FactClientTransactionsProgram[status]),FactClientTransactionsProgram[status]="Referred" )

% Difference = DIVIDE([In Program Count of status],[Referred Count of status])

Is this the output you expect?

Best Regards,

Community Support Team _Charlotte

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

[amitchandak]

@abeenish , One is use isinscope and replace count of status to % difference in grand total

if(not(isinscope(Table[Referral])), [% difference], [count of status])

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

or hybrid table

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc