Forum Discussion

SAPpowerbi's avatar
SAPpowerbi
Helper II
4 years ago
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   ...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • speedramps's avatar
    speedramps
    4 years ago

    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

speedramps's avatar
speedramps
Super User
4 years ago

Sorry you have completely confussed me. ☹️

Please close this tickjet and start again with an new ticket with an exampe of your source data and what you require.

Thanks 😁