cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RatanBhushan
Helper II
Helper II

How to use SUMMARIZECOLUMNS in measure for same table?

Hi Team

 

CalcTable = SUMMARIZECOLUMNS(KPISummary[Kpis],KPISummary[Quarter],KPISummary[SiteName],
"Result",AVERAGE('KPISummary'[Pass/Fail 1,0]))
 
Using above I have created a calculated table to get the below measure
 
CountofFail = COUNTROWS(FILTER(CalcTable,AND(CalcTable[Pass/Fail]="Fail",CalcTable[Quarter]<>"Q4"))).
 
Is there any way to use the above SUMMARIZECOLUMNS function in the same KPISummary Table to that I can get the above measure?
 
I am trying below but failing - 
 
RatanBhushan_0-1632288002583.png

 

 

Please advise me a better way.

 

Thanks and regards

RatanB

2 REPLIES 2
Tanushree_Kapse
Solution Supplier
Solution Supplier

Hi @RatanBhushan ,

 

You can't create summarized table in a variable. You need to create the table first and then, try creating DAXs using the columns in that table.

 

 

Mark this if I answered your question. Kudos are always appreciated.

Thanks.

Could you please share some idea of dax within the same dax which I have shared here?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.