Power BI Dax : Matrix

[ncbshiva]

Hi Friends,

Below is my input table with two columns

Difficulty to bridge the gap	How large is the gap to fill  (1 is no gap to fill, 5 is large gap to fill, i.e. several resources, if medium choose 3)
Easy	1
Easy	5
Hard	5
Hard	1
Medium	5
Medium	1
Medium	3
Hard	1
Easy	3
Easy	5
Hard	3
Medium	1

Kindly help me to write DAX function to get the below output.

	1 No Gap	3 Medium	5 Large
Easy	1	1	2
Medium	2	1	1
Hard	2	1	1

I want to count the number of time the Gap no for each of the difficulty level

For Example : Easy has 1 time for No Gap and 2 time for Large Gap.

Thanks

[luxpbi · Accepted solution]

Hi @ncbshiva, 

You don't need no DAX for this... 
 

You can use a Matrix visual. Put how large is the gap to fill in the columns and count this same colmn as I show you in the pictures. 

Regards,

[ncbshiva]

Thank you