Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Totalizer in column Power BI

Hello, good afternoon! Please, could someone help me to make a measure that adds the column "Dias" to the totalizer? Thank you.  
Need Help
  • VilmarSch's avatar
    VilmarSch
    3 years ago

    Veja se ajuda

     

     

    Dias = 
SUMX (
    SUMMARIZE ( dCalendar, [MesNum], [Dia] ),
    CALCULATE ( IF ( [Qtd] > 0, 1, "" ) )
)

     

     

VilmarSch's avatar
VilmarSch
Icon for Post Partisan rankPost Partisan
3 years ago

Veja se ajuda

 

 

Dias = 
SUMX (
    SUMMARIZE ( dCalendar, [MesNum], [Dia] ),
    CALCULATE ( IF ( [Qtd] > 0, 1, "" ) )
)