Forum Discussion

chonchar's avatar
chonchar
Icon for Helper V rankHelper V
3 years ago
Solved

Divide/ % of Total

Good morning. parry2k MFelix  I had the below measure working until I had to update a connection. But now, this measure is returning 100% for all screens:   % of Total Screens = Var _totaldomain...
Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    Or visualization because this measure should give you the same value in all the rows.

     

     

chonchar's avatar
chonchar
Icon for Helper V rankHelper V
3 years ago

rajulshah The relationships are working. The new table is the exact same as the old with a 1:M relationship. 

rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
3 years ago

chonchar Can you try using ALL on the table itself?

  • chonchar's avatar
    chonchar
    Icon for Helper V rankHelper V
    3 years ago

    rajulshah All is already on the table itself:

     It is still returning 1

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      3 years ago

      Can you share the calculation for the [Total Screens per Domain] please

      • chonchar's avatar
        chonchar
        Icon for Helper V rankHelper V
        3 years ago

        MFelix 

        Total Screens per Domain =
        COUNTAX(
            Appended_Fiscals,
            Appended_Fiscals[Domain]
        )