Forum Discussion
ncbshiva
Advocate V
Advocate VPower BI Dax : Matrix
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
