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
SAPpowerbi does your source data in pivot form? How your source data looks like? You need to unpivot it and then it will be super easy to work with.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
SOurce data -
| 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 |
| USA | Asus | 1/1/2022 | 100 |