multi table with var fonction in DAX

[GyMpX]

hello!

I need some helps to do this without creating many tables and overload my model.

I have the First table and want to have the red result. I think i need to create an intermediate table (2) in a var DAX but can't use new column.

If you can help me...

I find a solution by create 2 intermediates tables... but I need to do this with 3 Indicators (6 tables are created....)

Thank you a lot for your help!

[GyMpX]

hello! Thank you a lot for your answering but it's doesn't work... it gave me 100%

[v-yadongf-msft]

Hi @GyMpX 

Create following measures:

Number = COUNT('Table'[Top traitement])

rate = 
var _sum = SUM('Table'[Top traitement])
return
DIVIDE(_sum,[Number])

Measure = MAXX(FILTER(ALLEXCEPT('Table','Table'[Top traitement]),'Table'[Zone] = SELECTEDVALUE('Table'[Zone])),[rate])

Measure 2 = IF([rate] = MAXX(FILTER(ALLEXCEPT('Table','Table'[Top traitement]),'Table'[Zone] = SELECTEDVALUE('Table'[Zone])),[rate]),[Number])

Measure 3 = 
var _a = SUMX(ALLEXCEPT('Table','Table'[Top traitement]), [Measure]*[Measure 2])
var _b = SUMX(ALLEXCEPT('Table','Table'[Top traitement]),[Measure 2])
return
DIVIDE(_a,_b)

I think this is the result you want:

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.