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

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Hello SAPpowerbi ,

 

how does the source table look like?

 

Best regards

Denis

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

  • SAPpowerbi's avatar
    SAPpowerbi
    Icon for Helper II rankHelper II
    4 years ago

    Dummy SOurce Table -

    RegionClinet DateValue
    UKHP1/1/202211
    UKHP1/1/202211
    UKHP1/1/202211
    UKHP1/1/202211
    UKHP1/1/202211
    USADell1/1/2022100
      1/1/2022100