Forum Discussion
Calculate category average based on selected record
Hi,
In the Table visual, you will see 10.43 in the Grand total row
I was able to solve this and have it display on cards as intended with the following measures:
AvgLeadTimeSelectedProject =AVERAGE('Metric Table'[Lead Time])AvgLeadTimeSameMarketSector =CALCULATE(AVERAGE('Metric Table'[Lead Time]),ALL('Project Table'),'Project Table'[Market Sector] = SELECTEDVALUE('Project Table'[Market Sector]))
Hi,
I have solved a similar problem in the attached file.
Hope this helps.
Hi Ashish,
I think your solution is similar but I am lookin to do a calculation of the values associated with all matching categories. I wasn't able to attach a .PBIX but here is a screenshot of the sample data and use case. Note the Site Average Cards are averaging only the selected site, in this case B.
I am not sure of how much i can help but i can try. Share the download link of the PBI file.
Let me know if this link works for you Forum Sample Power BI.pbix
Hi,
In the attached PBI file, you will see the table working correctly with 73 being shown in the Grand total cell. What number do you want to see there?