Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 the total value.
For example, the total value for "Maint. Plans Targeted" column sould be 467, however because of my DAX formula of using the Average, the total value become 8.
Maint. Plans Target1 = Calculate(AVERAGE('Class 9 Maintenance Data_New'[Current Plan Target.1]),
HOW to solve this?
Thanks
Tuff
Solved! Go to Solution.
@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 -
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])
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 - 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])
User | Count |
---|---|
65 | |
60 | |
47 | |
33 | |
32 |
User | Count |
---|---|
86 | |
75 | |
56 | |
50 | |
45 |