Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

How to remove / avoid the totals

  • 1.  How to remove / avoid the totals

    Bronze Contributor
    Posted 5 days ago
      |   view attached
    Hi, I would like to avoid to show the figure (total) 385.50, please help

    Regards
    S

    ------------------------------
    Srikanth Hari
    FA
    ------------------------------

    Attachment(s)

    pbix
    Bi Test.pbix   377K 1 version
    Academy - Online Interactive Learning from Experts


  • 2.  RE: How to remove / avoid the totals

    Posted 4 days ago
    Hi Srikanth,

    If you want this:

    You can use this formula:

    Cost/Trip =
    IF(
    OR(ISINSCOPE('CC Master'[Station]), ISINSCOPE('CC Master'[Currency])),
    DIVIDE([ActCDS_CY~],([Trips_CY])),
    BLANK()
    )

    Regards!


    ------------------------------
    Pablo Barrachina Pastor
    Partner
    Sumamoos
    Alicante
    636695435
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: How to remove / avoid the totals

    Bronze Contributor
    Posted 4 days ago
    Thanks a lot, it's working now, Once more thing how can i put a serial no to the row here

    ------------------------------
    Srikanth Hari
    FA
    ------------------------------

    Academy - Online Interactive Learning from Experts