After add Diff % my table become many row ?

[Anonymous]

Hi All

Before i add the Diff % the table look okay :-

After Adding Diff % , the below table become many row , how to make it only one row ?

[Anonymous]

Hi @Paulyeo11 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[CNENFRNL]

Hi, @Anonymous , the superfluous rows result from measure or column (Diff %) that brings about unwanted, non-blank vlaues. If you attach some sample data, your issue would be way much faster to get pinpointed.

[Anonymous]

Hi Sir

[Anonymous]

Hi @Anonymous 

Can you show me your data model and what result you want？ This may make it easier for me to understand what you want.

LYTD Sales and YTD Sales are Measures, I need to know more about columns in your table, and the calculate logic of your LYTD Sales ,YTD Sales and Variance of Diff%. Diff% is a calculated column and make your first screenshot expand, you may try Max Function to get the Diff% by ((MaxYTD-MaxLYTD)/MaxLYTD).

Or you can share you pbix file with me by your Onedrive for Business.

Best Regards,

Rico Zhou

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