How to use measures in a pivot table properly?

[JollyRoger01]

I am trying to understand the purpose of measures and why they are even used (using Excel 2016). I have created a data model that I want to use in a pivot table. Someone told me that I should do all my calcs as measures, so I have done that. However, unless I use these measures in a column within the data model, they just provide a single number aggregate. When I try and use them in the pivot table, I get a single number across the entire table for all columns and rows, which is pointless. The only way for me to see useful information is if I reference the measures in the table colums within the data model so it has context., but this seems redundant as I could just use the same formula in the column. Can someone please tell me what the point of measures are and how to use them in a pivot table properly so that it takes the column and rows into context, or even provide an example where I would ever want to use a measure where I couldn't just sum up the columns in a pivot table to get the same value?

[amitchandak]

@JollyRoger01 , Seem like you create a model in power bi or power pivot and want to use that in pivot table.

Ideally, the measure should work fine. The measure has aggregation define. So when the measure is used alone it has one value. Without columns, they will display a single value. With columns, they will display grouped values (configured properly)  for those column values.

Can you share what exact issue you are facing with the sample

refer if needed

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/