North Kerala Power BI User Group

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

To remove the number from the Total

  • 1.  To remove the number from the Total

    Gold Contributor
    Posted Mar 18, 2021 05:37 AM
      |   view attached
    Hi Gopakumar, Could you please help me in removing the 3 & 1 from the KPI coloumn

    Regards
    SH



    ------------------------------
    FA
    ------------------------------

    Attachment(s)

    pbix
    Revtest (005) (002).pbix   602 KB 1 version


  • 2.  RE: To remove the number from the Total

    Top Contributor
    Posted Mar 19, 2021 04:41 PM
    Hi @Vinu Hari Please see if the following helps you. In your measure, move your current RETURN to a variable and then in RETURN you check for HASONEVALUE for category3. Something like this..
    IF(HASONEVALUE(Relation[Category3]),_finalvalue,BLANK())


    ------------------------------
    Gopa Kumar
    Limner Consulting

    North Kerala User Group Leader
    https://www.pbiusergroup.com/NorthKerala
    ------------------------------