Forum Discussion

SAPpowerbi's avatar
SAPpowerbi
Icon for Helper II rankHelper 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