Forum Discussion

gkarlo's avatar
gkarlo
Icon for Helper I rankHelper I
2 years ago
Solved

VALUES ARE NOT COUNTED NORMALLY

Hi, I hope someone could help me with this..

Actually  I have a table that a mesure counts normally as it should do, but when I delete the column "Category", the total count of projects regarding the category "Other" is only counted.

 

Table with category Column existing....

ProjectCategoryCount
Afree2
Afull5
Aother6
Bfree4
Bother15
Bfull10
Cfull7
Cother12
Cfree5

 

Behavior of the table when CATEGORY column is deleted. The category  Full and Free are not included, it only shows Other 

 

ProjectCount
A6
B15
C12

 

 Otherwise, the table must show as this:

ProjectCount
A13
B29
C24

 

I look forward to any comments please

Need Help

4 Replies

    • gkarlo's avatar
      gkarlo
      Icon for Helper I rankHelper I
      2 years ago

      Def MEASURE= Distinctcount('Table'[Project])

      The file I cannot share for confidentiality reasons 😞

      • tharunkumarRTK's avatar
        tharunkumarRTK
        Icon for Super User rankSuper User
        2 years ago

        If assume the project column in your measure and project column in your table visual are same then distinctcount should give you the following result, I am wondering how you result is different 


        Project DistinctCount

        A             1
        B             1
        C             1


        If the post helps please give a thumbs up


        If it solves your issue, please accept it as the solution to help the other members find it more quickly.


        Tharun



  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi gkarlo ,

    Please try this measure:

    Measure = CALCULATE(COUNT('Table'[Project]),ALLEXCEPT('Table','Table'[Project]))

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group