Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Total value in table report not showing correct value

Hi guru, I have question and hope you can provide a clue. I have a table report consists of three column fields (type: whole number). One of the column(i.e. Maint. Plans Targeted) is not providing ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous  - Sorry, that was a copy/paste mistake...Here is the corrected measure:

    Maint. Plans Target1 = 
var _avg = SUMMARIZE(
    FILTER(
        'Class 9 Maintenance Data_New',
        'Class 9 Maintenance Data_New'[FLOCDATASET]<>"1" && 'Class 9 Maintenance Data_New'[Reporting Month]=[This_Month]
    ),
    'Class 9 Maintenance Data_New'[Country], 
    "Average",AVERAGE( 'Class 9 Maintenance Data_New'[Current Plan Target.1])
)
return sumx(_avg,[Average])
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous  - 

Try something like this:

Maint. Plans Target1 = 
var _avg = SUMMARIZE(
    FILTER(
        'Class 9 Maintenance Data_New',
        'Class 9 Maintenance Data_New'[FLOCDATASET]<>"1" && 'Class 9 Maintenance Data_New'[Reporting Month]=[This_Month]
    ),
    'Class 9 Maintenance Data_New'[Country], 
    "Average", 'Class 9 Maintenance Data_New'(Sales[Current Plan Target.1])
)
return sumx(_avg,[Average])
I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
Nathan Peterson
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Peter,

    I hits error on the following line of the Dax...

     

    'Class 9 Maintenance Data_New'(Sales[Current Plan Target.1])

    May I know if Sales is a function? what did i miss out here? thanks

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Anonymous  - Sorry, that was a copy/paste mistake...Here is the corrected measure:

      Maint. Plans Target1 = 
var _avg = SUMMARIZE(
    FILTER(
        'Class 9 Maintenance Data_New',
        'Class 9 Maintenance Data_New'[FLOCDATASET]<>"1" && 'Class 9 Maintenance Data_New'[Reporting Month]=[This_Month]
    ),
    'Class 9 Maintenance Data_New'[Country], 
    "Average",AVERAGE( 'Class 9 Maintenance Data_New'[Current Plan Target.1])
)
return sumx(_avg,[Average])