Forum Discussion
Solved
Pivot Table - Add Column to Calculate Percent Sold
I have a spreadsheet with all of my companies accounts in Sales Force from the past year, both sold and unsold organized by zip code. The main purpose of what I'm using this for is to help better di...
Instead of using implicit measures you may add explicit DAX measures as
Sold:=CALCULATE(COUNTROWS(Range),Range[Sale Status]="Sold") Unsold:=CALCULATE(COUNTROWS(Range),Range[Sale Status]="Unsold") Total:=[Sold] + [Unsold]and use them in PivotTable
Ahoyt145 , you are welcome.
To sort: select More sort options
and here
zip codes
If manually you may slicers on fields from source data and filter by them
If by parameters we shall to define it somewhere in the grid (e.g. in parameters table), add it to data model and modify measures using such parameters.
Beautiful! Thank you again
Ahoyt145 , step by step... You are welcome