Forum Discussion

AnkurSharma's avatar
AnkurSharma
Icon for Helper I rankHelper I
3 years ago
Solved

Total missing in measure

Hi everyone,

 

I created one measure which shows count but it is not showing me total in the end. Thanks for your time and help. 

 

https://emails.azure.microsoft.com/redirect/?destination=https%3A%2F%2Fapp.powerbi.com%2FMobileRedirect.html%3Faction%3DOpenReport%26reportObjectId%3D1417f577-00a8-4e58-8496-92d2f23e6f65%26ctid%3D5ca9f2e0-b186-4263-b982-f2908b5ad472%26OpenAppFromWindowsPCAndTablet%3Dfalse%26emailSource%3DReportInvitation&p=bT1kMzNiYTBhYi04YTRlLTQ2ZWMtOGUyNC05ODc2ZDlkNzk5YTcmdT1hZW8mbD1Nb2JpbGVSZWRpcmVjdC5odG1s 

  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi, AnkurSharma 

    Try to add another measure like:

    Result = SUMX(VALUES(test[Company]),[Company count])

    Best Regards,
    Community Support Team _ Eason

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello please try 

    Correct Total = IF(HASONEFILTER(table[main column on your visual table]),[Your Measure]

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    AnkurSharma Not sure Anonymous 's message is 100% complete. Here is some additional information to help you understand what is likely going on. This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

    Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
    https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

    • AnkurSharma's avatar
      AnkurSharma
      Icon for Helper I rankHelper I
      3 years ago

      HI Greg 

      can you help me with Hason filter on this measure?

      CALCULATE(COUNTROWS('Sheet1'),FILTER('Sheet1',CONTAINSSTRING('Sheet1'[Column1],MAX(test[Company]))))

       

      i tried this but not working

       

      IF(HASONFILTER(

      CALCULATE(COUNTROWS('Sheet1'),FILTER('Sheet1',CONTAINSSTRING('Sheet1'[Column1],MAX(test[Company]))))

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hello the measure shoulf be the same so example

        Measure1 = CALCULATE(countrows(sheet1),filter(sheet1,containstring(sheet1[column1],max(test[company]))

         

        Then 

        IF(HASONEFILTER(table[main column on your visual table]),[Measure1]