Calculate doesn't show data for groups

[askkumar]

Hello Experts

I am trying to filter the data by reading data from slicers and displaying the same in visual, I am able to write the formula but the problem is data is shown as the grand total instead of it should be split by group and finally shown as the grand total.

I need to show the data per area and total at the end.

var Week_selected = SELECTEDVALUE('Table 3'[FISCAL_WEEK])

Var EndDate = MAXX(FILTER('Table 3','Table 3'[FISCAL_WEEK] = Week_selected), 'Table 3'[Date].[Date])

var data = SUMMARIZE(FILTER(ALL('Table 3'), 'Table 3'[Date].[Date] >= DATE(YEAR(EndDate),1,1) && 'Table 3'[Date].[Date] <= EndDate),'Table 3'[Area],"mins",SUM('Table 3'[minutes]))

return

SUMX(data,[mins])

In above image value is repeated for areas aswell but I need 130729 to be split for area level and need to get the same as total.

any help is appretiated.

Thanks

Siva

[Anonymous]

Hi @askkumar ,

You can create a matrix visual for your data instead of table visual. In order to get a better understanding on your requirement and give you a suitable solution, could you please provide more raw data in the table 'Table 3' (exclude sensitive data) with Text format, the visual settings and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[askkumar]

Thanks for reply, Apologize for the delayed response.

I have a dataset that has 2 years of data, My requirement is by selection of a slicer need to select the data and display in a matrix visual.

If my slicer selection is Feb-06-2023 then I am supposed to show the data from feb-01-2023 to Feb-06-2023 for all areas,

Expected Result                                                            Result I got

Area      Feb1-Feb6                                                       Area      Feb1-Feb6

Area1    500                                                                  Area1    1500                                                                   

Area2    1000                                                                Area2    1500

Total      1500                                                                Total      1500

so selecting partial data from full dataset in runtime or dynamic selection using the slicer value.

For this purpose I have used the formulas, I postes same in question.

I am struck at the point where using "SumX" is summing the data at grand total level but I need to get at group level then need the grand total

Will try to get sample data, apologize for not providing at this moment.

Thanks for the help