converting column to measure

[Russ99]

Hi Community,

I think this is a noobish question but one i am struggling with never the less. 

I have a column called name and a column called payment days, I want to be able to use payment days as a measure to create other measures but don't want to use sum to aggregate the column. I want the column shown below to be used as a measure 

I tried making using the dax formula "measure = sum[payment days]" but then the table looks like this

anyway i can make a measure that works exactly the same way as the column?

thanks

russ

[DataVitalizer]

Hi @Russ99 

Is the column Supplier Name you are using in your visual table coming from the same table from which you created the measure?

[Russ99]

yep they are related with a one to many relationship as intended. thanks for  your help

[DataVitalizer]

You have two related tables (A & B), in your report you added a visual in which you added Supplier name from Table A, and in the same visual you added a measure which calculates Sum [payment days]
If you have followed these steps the calculation is supposed to be correct.

In case you file does not contain sentivie data could you share a sample here?

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated

[Russ99]

yes it is, i do have supplier name in a different table, these tables are joined by this column

[DataVitalizer · Accepted solution]

Hi @Russ99 

Can you make sure that both tables are related to each other from the model view?

Did it work ? 👌Mark it as a solution to help spreading knowledge 👉A kudos would be appreciated