Forum Discussion
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?
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
3 Replies
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
Baskar 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 Baskar, 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 :)
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