Forum Discussion
Pivot Table Target Measure
Hi guys... I need your help with a measure in Pivot Table with Excel. My goal is to have a measure (DisplayTotalWeeks) based on qty of "SemanaMes". In the case, it must return 9 like the example ...
Anonymous Hi, try it DAX, add in sumarize colum "Criada em (Month)"
=COUNTROWS(
SUMMARIZE(
export_sensedata_atividades_2024_05_13;
export_sensedata_atividades_2024_05_13[SemanaMes];
export_sensedata_atividades_2024_05_13[Criada em (Month)]
)
)
Hi Dima,
I have try this before, and I believe that we are close because the result.
Criada em (Month) | SemanaMes | Qty Atividade | measure 2
| abr | 1 | 446 | 10 |
| abr | 2 | 11 | 10 |
| abr | 3 | 1 | 10 |
| abr | 4 | 3 | 10 |
| abr | 5 | 1 | 10 |
| mai | 1 | 524 | 10 |
| mai | 2 | 701 | 10 |
| mai | 3 | 1 | 10 |
| mai | 4 | 2 | 10 |
Grand Total 16905
Maybe on the measure now, because it must consider what is showed.