Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sKaiNet
Frequent Visitor

DAX - count inside group

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

Here is my data:  2016-12-20_1544.pngScreen 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:  2016-12-20_1550.pngIn 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?

 

 

 

 

1 ACCEPTED SOLUTION
Baskar
Resident Rockstar
Resident Rockstar

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

View solution in original post

3 REPLIES 3
Baskar
Resident Rockstar
Resident Rockstar

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 🙂

Baskar
Resident Rockstar
Resident Rockstar

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

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors