Drill through

[NewbieJono]

i have a table with transaction, volume, stream (Digital, Manual, intermidate)

i have dax to show percentage of each. but i mainly want to focus on digital.

My matrix table shows transaction, and digital percent.

when i drill through to transaction detail, the digital percent is alway 100 percent. it does not seem to be taking into account the other stream volumes Digital, Manual, intermidate)

% Digital = 

VAR Total = sum('FACT - Transactions'[Volume])
VAR Digital = [Digital Volume]

Return

DIVIDE(Digital,Total,"-")

[PC2790 · Accepted solution]

Hey @NewbieJono ,

For getting the "Total" to be used as a denominator in the DIVIDE dax, you would need to use ALL in order to remove the filters applied. You can try:

var Total = Calculate(Sum('FACT - Transactions'[Volume]),ALL(Stream[ColumnName]))