Forum Discussion

5 Replies

  • Astroraf's avatar
    Astroraf
    Data Integration
    12-16-2025

    Hi DRay​ ,

    The answer provided did not provide I solution. I will try a support ticket. 

  • HamzaJ's avatar
    HamzaJ
    Data Integration
    11-20-2025

    Hey Astroraf​ ,

    I think it is dependent on how the data is stored. If it is in the same table i think a you can do this with a formula that counts all categories (e.g. count(categories), ALL(filter1),All(Filter2)) . If it is stored in multiple tables then i do not think it is possible, unless;

    • you are on the newest linux version of sisense which supports join types and you can select a different join type then inner join
    • if the amount of categories is limited you can apply a measure filter (e.g. (count(ID), Category=A) per category and repeat it. 

    Hamza

    • Astroraf's avatar
      Astroraf
      Data Integration
      11-21-2025

      Hi HamzaJ​ 

      The formula is total of some value lets say total emissions, I want to show all the categories even if they have a zero value. They all coming from the same table.

      For the formula: SUM([Total Emissions])

      Assumption: (SUM[Total Emissions], ALL(Category)) -> Not sure if this would work. 

      • HamzaJ's avatar
        HamzaJ
        Data Integration
        11-22-2025

        Hey Astroraf​ ,

        I know there is a way to do this, but i cant recall the correct formula/steps. I tried it myself but couldnt get it. If there are not to much categories you could try the measured filter route. Otherwise I think a edit on datamodel level is needed.

         Hamza

  • DRay's avatar
    DRay
    Sisense Employee
    12-12-2025

    Hi Astroraf​,

    I’m following up to see if the solution offered by HamzaJ​ worked for you.

    If so, please click the 'Accept as Solution' button on their post. That way others with the same questions can find the answer. If not, please let us know so that we can continue to help.

    Thank you.