Forum Discussion
Help with Data Filters & Relationships
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.
7 Replies
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.
There isnt a measure for my count. It is just a count of the Event Name (Rows).
I think you should sum the values not count them when pivoted
So how can I figure out what goes missing when I pivot the data?
can you link the pbix or get a sample data as your structure to see how we can help you.
