Forum Discussion
Count without blank rows
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.
Hey Hi ,
Source data is already unpioted , in above example i am using source as a matrix table from my Visvalization - i want ouput based on that -
basically i want count without blank and the total.