Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Nasrullah
Regular Visitor

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

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])

Nasrullah_0-1674249012717.png

 

1 ACCEPTED SOLUTION

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]
)

yingyinr_1-1674552354936.png

 

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

10 REPLIES 10
Nasrullah
Regular Visitor

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.

 

Nasrullah_3-1674329562587.png

 

 

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.

 

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!

@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.
 
Nasrullah_0-1674455551168.png

 

 

 

Hi @Nasrullah 

 

Please try thw following Measure

Price with sum =

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

 

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.

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!

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.

Nasrullah_0-1674546233559.png

 

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]
)

yingyinr_1-1674552354936.png

 

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @Nasrullah 

 

ok, Can you ow please try:

Price with sum =

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

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.

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!

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.

Nasrullah_0-1674551965485.png

 

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 @v-yiruan-msft  which also looks promising. If both dont work please share your data model.

 

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.

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!
FreemanZ
Super User
Super User

hi @Nasrullah 

Unable to follow you, could explain the expectation further?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors