cancel
Showing results for
Did you mean:
Regular Visitor

## Re: Total value for all rows

Yes, in this case it could be the issue in Axis value. Try to make Table only with Raw attributes and the measure during the date. It should give you the result. The formulas are perfectly OK.

Member

## Re: Total value for all rows

Hi, @Pavlous and @Floriankx and thank you very much for your comments.

Really, Concepte FAC it's not a calculated column, it's a field in the table. The Table1 is the result to Append two tables (TableA and TableB) with this fields:

TableA (Date, CodArea, Col, Cost)

TableB (Date, CodArea, Col, Concepte, Fact, ConcepteFac) where Concepte Fac it's a calculated column: IF(Concepte<>"", Concepte, Col)

The result Table1 it's (Date, CodArea, Col, Concepte, Cost, Fact, Concepte Fac). I try to change the calculated  column by the concatenate formula and I explain how it has gone.

Thanks.

Moderator

## Re: Total value for all rows

@Raul,

Please check if the Matrix visual in the following PBIX file  returns your expected result.

https://1drv.ms/u/s!AhsotbnGu1Nok1trPckl3J_1DQa1

Regards,
Lydia

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

## Re: Total value for all rows

Your exemple it's awesome , thanks a lot. This is exactly what I want and the two matrix tables present the correct results.

But, I changed the conditional column by the calculated column concatenating the two fields as @Floriankx commented and the result, in my case, is still incorrect. It's the same as I had with the conditional column and I can not show the totals by Area in the whole column.

What's happens?

Member

## Re: Total value for all rows

A difference between your Table1 or Merge1 origin table and my table are that the values of the rows for the Cost and Fact columns are null intead of blank that your exemple.

Merge1

My table.

Could this be the problem? Thank you.

Member

## Re: Total value for all rows

No, that is not the problem. I have changed the null values by 0 and the result is still incorrect:

Member

## Re: Total value for all rows

This is the data for the table:

Thank you very much in advance!

Member

## Re: Total value for all rows

Good morning!

I've reduced tha data model to a unic table from previus Excel file and the result it's the same:

Member

## Re: Total value for all rows

I've found the solution!!!

The formula for the measure is:

TempCOST = CALCULATE(SUM(Table1[Cost]);ALLSELECTED(Table1);VALUES(Table1[Area]))

Thank you @v-yuezhe-msft@Pavlous and @Floriankx for your help.

Bye!!

Announcements

#### Community Highlights

Find out what's new in the Power BI Community!

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 319 members 2,875 guests
Recent signins: