Forum Discussion
Working with duplicate records
I have data of the given format
| batch | records | payment method | country | region | pay description |
| 1 | 30 | Amex | US | Americas | card invalid |
| 1 | 30 | Amex | US | Americas | card limit exceeded |
| 1 | 30 | Amex | US | Americas | card invalid |
| 1 | 30 | Amex | US | Americas | card invalid |
| 2 | 60 | Mastercard | JP | ASIA | Insufficient balance |
| 2 | 60 | Mastercard | JP | ASIA | invalid zipcode |
| 2 | 60 | Mastercard | GB | EMEA | card expired |
| 3 | 80 | VISA | GB | EMEA | card expired |
| 3 | 80 | VISA | GB | EMEA | card expired |
i am trying to present records values in unique format in power BI. to show distribution and trend.
but when i rollup it gets summarized.
Has anyone seen this before and can provide a solution
Hi, Anonymous
Due to the characteristics of powerbi, if there is exactly the same data between rows, it will be automatically omitted in visual and only one row will be displayed. If you want to distinguish them, the easiest way is to add an index column in PQ.
Like this:
If it doesn't solve your problem, Please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
In any visual when you these column
batch records payment method country region you will get unique data
or you can create meusre like
measure = countx(summarize(Table, [batch],[records],[payment method],[country region]), [Batch])
or can create table summarize(Table, [batch],[records],[payment method],[country region], "Max" , max([pay description])),
- v-janeyg-msft
Community Support
Hi, Anonymous
Due to the characteristics of powerbi, if there is exactly the same data between rows, it will be automatically omitted in visual and only one row will be displayed. If you want to distinguish them, the easiest way is to add an index column in PQ.
Like this:
If it doesn't solve your problem, Please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
