Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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])
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
31 | |
27 |
User | Count |
---|---|
92 | |
50 | |
44 | |
40 | |
35 |