How to round up a calculated measure?

[lennox25]

I have this measure to calculate No of Visits

No of Visits = CALCULATE (SUM ('Table', [StoreNo]) / 7)

The problem is when I check on the outcomes ( choice of 4) of the visit and the KPIs (7 - which is why divided by 7 as there are 7 rows for each store) on dividing the Count of Visits for some of the outcomes is 0 as the result is  say 0.4 .

My question is what do I need to do to round up the calculated measure?

[Syndicate_Admin]

Thank you very much!

[v-zhangti · Accepted solution]

Hi, @lennox25 

You can try the following methods.

No of Visits = DIVIDE(SUM ('Table'[StoreNo]),7)

Measure = ROUND([No of Visits],0)

Is this the result you expect?
ROUND function (DAX) - DAX | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@lennox25 no idea what you are trying to achieve and this measure doesn't look correct to me:

Measure = SUM ( Table[Column] ) / 7 

or

Measure = COUNTROWS ( Table ) / 7

[Ahmedx]

if you need to round down then use this

ROUNDDOWN([No of Visits],0)