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 what represents A/B/C from your original post. Can you stick to one data table? How do you expect someone to help you if you keep on changing the data? Just my 2 cents.
Ha ha ha I agree with parry2k.
You did change the data in the problem description.
Which is a bit frustrating when volunteers are trying to help.
Glad we found you a solution.
But keep problem descriptions simple next time please 😀😀😀