How to use SUMMARIZECOLUMNS in measure for same table?

[Anonymous]

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 - 

Please advise me a better way.

Thanks and regards

RatanB

[Tanushree_Kapse]

Hi @Anonymous ,

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.

[Anonymous]

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