Help with Data Filters & Relationships

[carter1208]

I have a spreadsheet of data that has Learner Types across the top as shown below. Each row has a number for that learner type that attended the event of that row. 

THe problem is I need to filter based on these column headers. I pivoted the data, but then when I build my dashboard I get incorrect counts, such as the total of events in the pivoted table vs the actual number (Confirmed in Excel). Not sure where to go from here. Any help would be appreicated. 

[Idrissshatila]

Hello @carter1208 ,

the right approach if you want to filter by the column types is to pivot the table, then you need to know why the count is getting wron, maybe you're doing something wrong in the measure.

[carter1208]

So how can I figure out what goes missing when I pivot the data?

[Idrissshatila]

@carter1208 ,

can you link the pbix or get a sample data as your structure to see how we can help you.

[carter1208]

See Link below for sample data

Link 

[Ashish_Mathur]

Hi,

The first thing you should do is Unpivot the Learner columns.  In the Query Editor, select columns A:I, right click and click on "Unpivot Other Columns".  Now build your visuals.

[carter1208]

There isnt a measure for my count. It is just a count of the Event Name (Rows).

[Idrissshatila]

@carter1208 ,

I think you should sum the values not count them when pivoted