topic Re: Need Help In Sum Function for begineer in DAX Commands and Tips

Need Help In Sum Function for begineer

Abhijsrwala1 — Thu, 09 Jun 2022 07:48:40 GMT

The Total of this column is 358.

When I create the measure with the formula =sum(sch Time) it gives me 83!

When I create a column with formula=sumx(table name, sch time) it gives corect result 358 but it is populated as a column, where all rows have same values.

Can't a measure be created which gives 358.
PS: Sch Time is a calculated column

Re: Need Help In Sum Function for begineer

tamerj1 — Thu, 09 Jun 2022 08:24:19 GMT

Hi Abhijsrwala1
The measure should give the same value. What changes in the case of measure is the filter context. There must be some filter applied which you rae not aware of.

Re: Need Help In Sum Function for begineer

Anonymous — Tue, 21 Jun 2022 07:51:35 GMT

Hi Abhijsrwala1 ,

How did you set your visual in Power BI? And if you set any filter on the visual or create a slicer to filter the data? Please update the formula of your measure as below and check if it can get the correct result:

Measure = CALCULATE ( SUM ( 'tablename'[sch Time] ), ALL ( 'tablename' ) )

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. 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

Re: Need Help In Sum Function for begineer

Anonymous — Wed, 06 Jul 2022 06:09:55 GMT

Hi Abhijsrwala1 ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards