topic Re: Hi, i need to show "total value" of "don`t summarized" column. in DAX Commands and Tips

Hi, i need to show "total value" of "don`t summarized" column.

Nasrullah — Fri, 20 Jan 2023 21:14:21 GMT

I am using table visulizaition, and I am trying to show the total for “don`t summarized” column.

i used the following Dax expresssion to make Billing Rate $/Hr column don`t summarized. but i need the total of Billing Rate $/Hrs column.

Billing Rate $/Hr = SELECTEDVALUE('Project Role Price'[msdyn_price])

Re: Hi, i need to show "total value" of "don`t summarized" column.

FreemanZ — Fri, 20 Jan 2023 22:53:54 GMT

hi Nasrullah

Unable to follow you, could explain the expectation further?

Re: Hi, i need to show "total value" of "don`t summarized" column.

Nasrullah — Sat, 21 Jan 2023 19:33:36 GMT

The billing rate $/Hrs value is not summarized.

As per my reuqirements i don`t want summarized value of billing rate $/Hrs column. but i want to show the Total of billing rate $/Hrs column.

can you please help that how to show the Total of billing rate $/Hrs column.

please have a look at the below screenshot.

Re: Hi, i need to show "total value" of "don`t summarized" column.

Mikelytics — Sat, 21 Jan 2023 19:37:04 GMT

Hi Nasrullah

TO be honest I agree with FreemanZ that the requirement is not clear

Maybe the following?

Measure = SUMX( 'Project Role Price', [msdyn_price] )

If not please specify:

- what is as-is state

- which measures are you currently using

- what is the target state

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

Re: Hi, i need to show "total value" of "don`t summarized" column.

Nasrullah — Mon, 23 Jan 2023 06:34:17 GMT

Mikelytics the billing rate $/hrs colunm didn`t show the total value.

currently im using the following measures.

Billing Rate $/Hr =

SELECTEDVALUE('Project Role Price'[msdyn_price])

i want to show the total value of billing rate column.

but keep in mind the billing rate column is not a summarized column.

Re: Hi, i need to show "total value" of "don`t summarized" column.

Mikelytics — Mon, 23 Jan 2023 07:29:34 GMT

Hi Nasrullah

Please try thw following Measure

Price with sum = SUMX( VALUES('Project Role Price'[msdyn_price]), [msdyn_price] )

Re: Hi, i need to show "total value" of "don`t summarized" column.

Nasrullah — Tue, 24 Jan 2023 07:44:11 GMT

Hi Mikelytics,

i tried the above Measure but it calculate the wrong Total value of Price with sum column

the total value of Price with sum column should be 375 but it showing 210

please have a look at the below screenshot.

Re: Hi, i need to show "total value" of "don`t summarized" column.

Mikelytics — Tue, 24 Jan 2023 07:53:53 GMT

Hi Nasrullah

ok, Can you ow please try:

Price with sum = SUMX( 'Project Role Price', [msdyn_price] )

Re: Hi, i need to show "total value" of "don`t summarized" column.

Nasrullah — Tue, 24 Jan 2023 09:31:14 GMT

Hi Mikelytics

the above Measure are sum all the value in Price with Sum column.

i don`t wanna sum Price with Sum column value.

i want total value of Price with Sum column.

please have a look at the below secreenshot.

Re: Hi, i need to show "total value" of "don`t summarized" column.

Anonymous — Tue, 24 Jan 2023 09:27:07 GMT

Hi @tomsmith213 ,

You can create another new measure as below and put this new measure to replace the original measure [Billing Rate $/Hr] onto the table visual. Later check if it can return the correct total values...

New Measure = SUMX ( GROUPBY ( 'Project Role Price', 'Project Role Price'[Project], 'Project Role Price'[Resource], 'Project Role Price'[Role], 'Project Role Price'[Organization Unit] ), [Billing Rate $/Hr] )

In addition, you can refer the following links to try to solve your problem...

Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand

Dax for Power BI: Fixing Incorrect Measure Totals

If the above one can't help you, could you please provide more raw data in your table 'Project Role Price' (exclude sensitive data) with Text format 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

Re: Hi, i need to show "total value" of "don`t summarized" column.

Mikelytics — Tue, 24 Jan 2023 09:44:50 GMT

Hi Nasrullah,

I think in general by modifying your data model you would not run in this problem. Can you show it please since to really help you I need to understand the granularity of your price. Which combination of fields has a defined price. I give it another try without knowing the data model but in the end its risky to use it without udnerstanding it compoletely.

Please try:

Price with sum = SUMX( VALUES('Project Role Price'[msdyn_price]), AVERAGE([msdyn_price]) )

If this does not work please also take a look on the solution of Anonymous which also looks promising. If both dont work please share your data model.