Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

DAX - count inside group

Hi, I'm learing Power BI and have some difficulties constructing expression.  

Here is my data:  Screen from excel, but in desktop I've created calculated column to represent "Date Label". Now in report (for example in table) I want to calculate total number for each category per Date Label and then divide this number on total records per Date Label. 

Here is the screen illustrating what I'm trying to archive:  In short I want to group by Date Label and make a calculation for each category per Date Label.   

I've tried calculated column, but it doesn't work, because calculated column works at the row context. I've tried also creating measure, but I'm no able to calculate a sum per Date Label. 

Can you help me creating appropriate DAX formula?

 

 

 

 

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago
      Anonymous wrote:

      Hi,

       

      This is simliar to your prob pls have look on this 

       

      http://community.powerbi.com/t5/Desktop/Writing-a-more-efficient-DAX-measure/m-p/104394#U104394

       

      if not let me know i will help u

      Thanks Anonymous, from your answer in another thread I found the solution. But now I have another question :). I will start separate thread. 

      Actually I do a lot of development in .net, but never touched BI. A lot of question, but this is really really interesting and exciting, like a whole new world you was never aware of :)

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hey Skainet , 

        Basically me too .Net Developer ,

        BI reduce your workload and give as the meaningfull story about data summary.

         

        Lot of BI is there Tableau, Qlikview,Dundas.

        but Power BI is one of the best in my point of view. u can learn very short time . Cheers dude