table values without sum

[NadeemAhamed]

Dear All,

Good Day.

I have one table data with the month and month filters

I have tried multiple way to avoid the values getting sum but not happening. 

I have attached the pbix file for your reference. 

https://toyotsu.box.com/s/hrywd6ywmjsynjpird2pqsku9k5lthds

Requirement: when we are selecting the month the table values should shows only the values of selected month and division. 

the values should not get sum. 

Thank you in advance.

[danextian]

hI @NadeemAhamed ,

Your data model is not in the desired format and will be quite a maintenance in the long run. Imagine having 5 years worth of months which is equivalent to 60 columns and you'll have to create a measure for each -- and then add the need to modify them. I unpivoted your data and added sort columns.

That aside, measures are always aggregated one way or another. The three measures in your samplex pbix, they being measures, will always be summarized depending on the current row context. Add an index column in query editor and include this column in your visual so the measure shows row by row as in the data table.  Since your data has been unpivoted, you need only one measure for all months.

I also removed FORMAT from your measure and use dynamic format strings instead.

[NadeemAhamed]

@danextian 

Thank you for your valuable time to read and reply me.

Sorry to say this, i dont want to increase the row level. 

I want to show the values in column wise bcz we have to show only for Apr-Mar month data. 

So could you please tell how to avoid values to get summed up.

[NadeemAhamed]

@danextian 

Thank you for your valuable time to read and reply me.

Sorry to say this, i dont want to increase the row level. 

I want to show the values in column wise bcz we have to show only for Apr-Mar month data. 

So could you please tell how to avoid values to get summed up.

[danextian]

I might have misunderstood you. What do you mean by not summed up?  Can you please post a screenshot your desired result the way you exactly want it?