Count problem

[Presti73]

Hello everybody,

I am farely new to PBI and am trying to solve a problem for some days now. I can't imagine anymore what i haven't tried, measures, (DAX) and (M) formulas, distinctcount, duplicate tables, reference tables, but nothing seems to work and i can't find a solution.

I have a table with numerous colums. De table is being updated regularly and the number of rows are growing.

The table consists of a questionary with only 4 possible answers. However the questionary itself has around 25 question.

What i need to get is this:

The date field is only for filtering.

Can anybody help me do this?

Thanx in advance!

[dax · Accepted solution]

Hi @Presti73 , 

You could try to transform data structure, choose Q1~Q5 columns, then click "unpivot column" in Edit Queries, and use this in Matrix, you will get result you want. You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Presti73]

Thank you both for your solution!

The unpivoted columns did the trick. Keeping columns in on wich filters could be based, made it very versatile and usable on all visuals.

[Greg_Deckler]

Seems like you need a multi-column aggregation: https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-...