cancel
Showing results for
Did you mean:
Regular Visitor

## Re: Calculate % divide by a fixed monthly number

The measure is doing this:

Excel: 165/160 = 105%
PBI: 165/160 = 10.4%

The problem is that Power Bi is showing 10.4 instead of 104% and I don't know why.

Regular Visitor

## Re: Calculate % divide by a fixed monthly number

@chirayuw is it possible to make a filter in that DAX you sent me in the sample for Holiday where instead of 0 it counts as 4?

Regards,

Member

## Re: Calculate % divide by a fixed monthly number

Hi, Edited the formula in the Calendar Table to say 4 for Sat/Sun/ Holiday. Or do you want Sat + Sun as 0 but Holiday as 4

Also I've almost redone the file because I was trying to fix the issue of not going above 100%

Have a look and let me know if this is what u need

https://ufile.io/jc0o0

Announcements

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

#### PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 6 members 2,378 guests
Recent signins: