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

selimovd's avatar
selimovd
Most Valuable Professional
4 years ago

Hello SAPpowerbi ,

 

how does the source table look like?

 

Best regards

Denis

SAPpowerbi's avatar
SAPpowerbi
Helper II
4 years ago

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.