Table Visual - Help

[LearnPowerBIAS]

Hi Friends,

When I try to add a new coulmn into the table visual the rows are getting duplicated. If I add the coulmn (Comments), the remaing coulmns are showing like this. How to fix this issue.. please advise. 

Name	Subject	Comments	Test1	Test2
SA	Maths		50	50
SA	Maths	Pass	50	50
ASH	Computer		45	50
ASH	Computer	Improve	45	50
ARVi	English		30	30
ARVi	English	Fail	30	30

Thanks

[Anonymous]

Hi @LearnPowerBIAS ,

According to your description, here are my steps you can follow as a solution.

(1) We can create a measure. 

Flag = IF(MAX('Table'[Comments])=BLANK(),0,1)

(2)As shown in the following image, [Flag] is placed on the filter of the visual, and the result is as follows.

Best Regards,

Neeko Tang

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

[LearnPowerBIAS]

No, I cant use this formula. There are some more rows coming as null. 

[Anonymous]

Hi @LearnPowerBIAS ,

Please check if your Comments column has null values itself? Click "Transform Data" to enter the Power Query editor, filter out the null values of the data, and click "Close and Apply". Or select all columns except Comment, perform Group By, and then add the aggregate column with the maximum value of Comment.

If not help, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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

[alekhved]

hi @LearnPowerBIAS 

What's the calculations used in the new calculated columns?

Thanks!