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

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