Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 |
---|---|
84 | |
82 | |
66 | |
52 | |
46 |
User | Count |
---|---|
100 | |
48 | |
42 | |
39 | |
38 |