Forum Discussion

Stevianne's avatar
Stevianne
Frequent Visitor
4 years ago

matrix count distinccount values

Hi all,

 

For this matrix I made use of a measure distinccount with a crossfilter in it. 

How can I add the values to a correct total? now everything is 1, While that is

not always correct. In case of row 2 it need to be 5.

 

 

Need Help

6 Replies

    • Stevianne's avatar
      Stevianne
      Frequent Visitor
      4 years ago

      Hi Parry

       

      Thanks for your advice. I made a dummy file. I don't know how to attach the file so I made some printscreens maybe that helps:

       

      Model

       

      Desktop

       

      Measure

       

      For this matrix I made use of a measure distinccount with a crossfilter in it. 

      How can I add the values to a correct total? now everything is 1, While that is

      not always correct. In case of row 2 (B) it needs to be 3.

       

      thanks in advance!

       

       

    • Stevianne's avatar
      Stevianne
      Frequent Visitor
      4 years ago

      I contacted my organization. Unfortunately it is not possible to share it by one drive. I also do not see a option to upload my pbix file. Are there any other options?

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi Stevianne 

    I see this post is not active recently, has the question been solved? 

    If you have solved the question, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

    If not, could you provide a sample file or some sample data, so that I can reproduce it.

    and then please check whether the outcome bellow is right.

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.