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
As promissed here is a solution using unpivot.
Please click the thumbs up and Accept As Solution to leave kudos