Forum Discussion

3 Replies

  • 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