"DO NOT SUMMARIZED" column needs to show "total"

[Anonymous]

Hello Communties,

Can you please suggest for below scenarios?

I am using TABLE VISULIZAITON,and I am trying to show the total for “do not summarized”options.As per my requirements I  need to ignore “Sales ” if transactions has “DEALER”.

THIS IS A CALCULATED COLUMN IN POWER BI>>if condtion = CALCULATE(SUM(Sheet1[Sales]),Sheet1[Transactions]<>"Dealer")

I want to use “ DO NOT SUMMARIZED” options in TABLE VALUES and I want to show TOTAL for sales and if condition column.

 

[v-jiascu-msft]

Hi @Anonymous,

I would suggest you create two measures. If we set it "Do not summarize", how can it summarize the column.

Best Regards,
Dale

[Shamatix]

Well I dont see the issue?
I also want a table with a TOTAL at the bottom but I dont want it to summarize as ill be missing rows basically.

The only way out of it, is to add a new column with a unique value in (Really ugly solution and shouldnt be nessesary, but it is today).

 have a table lets say it contains 3 colums A, B and C and has the Following Values

A  |B |C

Bo|1 |0

Bo|1 |0

Kik|2|3

-------

    |4|3

But today in power bi when I use a "SUM" it shows it as follows:

A  |B |C

Bo|2 |0

Kik|2|3

-------

    |4|3

I Know I can add a unique ID column to the table and that it will turn out correctly and show ALL the rows, but I find it to be an ugly solution. How can I have it shows the totals at the bottom AND all the rows, without making some "Hack solution" if you get me 

[Anonymous]

Hi Dal

thank you so much for your advice.As per my reuqirements i cannot summarized but still business wants to see total.I have chnaged table visulization to Matrix visulization and it should works.

Thanks