Forum Discussion
Solved
Count without blank rows
Hello Team , Please help me for below issue . Source data in mtrix Table - Service line A B C Client Name (Revenue) (Revenue) (Revenue) HP 100 10 Asus 10 ...
Hi SapPowerBI
No DAX is required ! 😀
In Power Query unpivot you table to this ...
Then create a visual table
with Service and Count Value.
I will send an example in few minutes
Dummy SOurce Table -
| Region | Clinet | Date | Value |
| UK | HP | 1/1/2022 | 11 |
| UK | HP | 1/1/2022 | 11 |
| UK | HP | 1/1/2022 | 11 |
| UK | HP | 1/1/2022 | 11 |
| UK | HP | 1/1/2022 | 11 |
| USA | Dell | 1/1/2022 | 100 |
| 1/1/2022 | 100 |