cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dhiraj Frequent Visitor
Frequent Visitor

DAX

I have a Production table, DimDate table. I needed to display weekly sum which I was able to do using SUMMARIZE function. Output of SUMMARIZE function is in 'TableS' with 2 columns WeekNo, SumP.  Now after creating relationships between these 3 tables, when I display the data, it is coming as :

Day   WeekNo.     SumP

1            1           129871

2            1           129871

3            1           129871

4            1           129871

5            1           129871

6            1           129871

7            1           129871

 

I want to display the figures in SumP column only when Day ==7(The Day information is in DimDate table). Please suggest how to do it.

7 REPLIES 7
Super User
Super User

Re: DAX

@Dhiraj i don't think you need to create summarize table, you can achieve everything using production and dimdate table. just share sample production data and expected output and will get you the solution.

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






Dhiraj Frequent Visitor
Frequent Visitor

Re: DAX

Capture.PNG

 

Similarly data will be for different weeks and sum needs to be done for every week but will be shown only on Saturday in SumP column which we can get by Day column after checking value equal to 7.

Super User
Super User

Re: DAX

@Dhiraj  can you put it in a more readable format? 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






Dhiraj Frequent Visitor
Frequent Visitor

Re: DAX

Yeah updated picture of data.

Super User
Super User

Re: DAX

@Dhiraj just to confirm, is this what you are looking for? I Just did two weeks

 

image.png




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






Dhiraj Frequent Visitor
Frequent Visitor

Re: DAX

Yes correct. You got it what I am trying to do.

Super User
Super User

Re: DAX

@Dhiraj  add following as a measure

 

SumP = 
SUMX( 'DimDate',
IF( 'DimDate'[Day] = 7,
CALCULATE(
SUM( Table1[Production] ) ,
ALLEXCEPT( 'DimDate', 'DimDate'[WeekNo] )
)
)
)



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin