Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hello,
I will try to explain my problem but it is a little bit complex to understand. So basically, I have a dataset in which each rows represent a transaction. Each transaction can be considered either "native" or "cobadge. The thing is I try to create a table to show the repartition between "native" and "cobadge" in this dataset, here is what I want from Excel I try to do it in powerbi :
I don't know how to create 2 rows and calculate everything based on those two rows.
Can anyone help me ?
Thank you!
@Wael03 ,
Can you share sample data and sample output in table format?
The output you have shown, we can get in matrix visual, if "native" and "cobadge are row values
| User | Count |
|---|---|
| 45 | |
| 35 | |
| 27 | |
| 17 | |
| 14 |
| User | Count |
|---|---|
| 62 | |
| 57 | |
| 41 | |
| 21 | |
| 20 |