Number of Rows, before unpivot.

[StuartSmith]

I had a table that had roughly 140 rows, but due to the way the data was presented, I had to "Unpivot" several columns, resulting in the table now having over 700 rows. The problem is that now any visuals see the 700+ rows and not the actual/original number of rows, resulting in incorrect values.  

I thought I could inport the origianl table in again as a 2nd table, and get values from there, but one of the values i need to display is one of the unpivited columns, so that that doesnt work.

How do people get pre-unpivoted values on a pivoted table.   I hope that makes sense.

Thanks in advance.

[amitchandak]

Check if there already a key column before unpivot. the distinct count can give the number post unpivot.

Or create an index column before unpivot and then try. But I doubt this one.

[StuartSmith]

No columns have unique values.  How do people work with pivoted data as its causing me lots of issues as its changed the table completely by adding 600+ extra pivoted rows, resulting in visuals taking into account these extra rows and not the actualy rows from the original unpivoted table.

[v-kelly-msft]

Hi @StuartSmith ，

Can you choose another way instead of unpivoting columns ,such as creating a calculated column or measure to achieve what you need?

Can you provide some sample data if it's not confidential?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!