Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
4 years ago
Solved

Drill through

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,"-")
Need Help
  • PC2790's avatar
    PC2790
    4 years ago

    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])) 

1 Reply

  • PC2790's avatar
    PC2790
    Community Champion
    4 years ago

    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]))