Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

help to make a matrix

i make a dax where i found the average about my notes, and make a matriz where a put my iqs names in the rows and month/year in columns, this dax where i found my average is

iqs = 

var Media = [Media Nota (Sem Ref)]
var satisfeito = IF(CALCULATE(COUNTROWS(f_BD_PSP),d_Indice[Indice] = "Satisfeito") = BLANK(),BLANK(),
FORMAT(Divide(CALCULATE(COUNTROWS(f_BD_PSP),d_Indice[Indice] = "Satisfeito"),COUNTROWS(f_BD_PSP)),"00.00%"))

return
if(SELECTEDVALUE(d_IQS[Categoria]) = "Índices de Satisfação", Satisfeito, media)

 

this dax genarate this matriz

 
 

 

 

 

but i want to make a dax to count how many months/years (my values painted red) is under my d_IQS[Padrão] so that i make my new matriz, is the example the matriz i want to make

 

 

the values is the count months/year where my value is under d_IQS[Padrão], its a example

VALUE([IQS]) < average(d_IQS[Padrão])

 

 

 
 
Need Help
Tutorial Requests

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    Anonymous , You need measure like

     


    Countx(Values(Table[Month Year]),calculate( if([IQS] < average(d_IQS[Padrão]), [Month Year], blank())))