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 would you mind pasting what the source data looks like? Paste it in the table format? it should be straight forward but need to see how the source data looks like?
✨ 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.