Forum Discussion
hellokitty0234
Jan 25, 2023Copper Contributor
how to add specific values to pivot table on excel?
hello,
hellokitty0234
Jan 25, 2023Copper Contributor
reply
SergeiBaklan
Jan 25, 2023Diamond Contributor
In general creating PivotTable you may add data to data model, generate DAX measure
Count negative:=CALCULATE( COUNTROWS( Table1 ), Table1[value] < 0 )
and use it in PivotTable: