Forum Discussion

Abhijsrwala1's avatar
Abhijsrwala1
Frequent Visitor
4 years ago

Need Help In Sum Function for begineer

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 ...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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