Help with Data modelling

Hi dandamudisanjay ,

Here what you want to achieve is to unpivot your dataset, to go from what you have to:

Customer ID / Sport

1 Cricket
1 Football
1 Baseball
1 Golf
2 Hockey
3 Tennis
....

You'll find here a .pbix with an example based on your use case.

The steps I took are the following

1. Unpivot and prepare your data in Power Query

2. Filter out rows for which the value is false

3. Create a measure that counts the number of players per sport

Step 1 : unpivoting the data

- you select the columns with names of sport

- and then Transform > Unpivot Columns > Unpivot Columns

The next steps in Power Query are:

- renaming Attribute to something more meaningful like Sport

- filtering out on the value column rows with FALSE

- removing the value column which is now useless as it only contains TRUE

Step 2 : creating your measure in Power BI

Here it's simple:

Count of Players = COUNTROWS( SportsData )

Step 3 : create your visual

Also, there are some great content which explain you more about the unpivot step in PowerQuery, I'll let you search the web/youtube.

I hope it helps. Does it?

Best,

Thomas