Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Ahead4097
Helper I
Helper I

Decimals in Measure

I'm using a table called "IV Data". I have a column named "CallfilevisitID" and one that is a key column that combines "Username" and "InterventionDate". 

I've created a measure to distinct count my CallfilevisitID column, and one to distinct count my key column. They are called "Distinct Count CallfilevisitID" and "Distinct Count Days by User". 

I then created a measure to Divide Distinct Count CallfilevisitID by Distinct Count Days by User to give me an average of the number of calls per day by user. 

The average measure is returning a rounded version of the average, and I need it to return the actual average down to 2 decimal places. 

Both The CallfilevisitID column and the Key column are text. 

 

Is it possible to have the average return as a non-rounding decimal number?


Thanks!

1 ACCEPTED SOLUTION
Cmcmahan
Resident Rockstar
Resident Rockstar

Very possible.  In the Fields pane to the right, select the measure in question.

 

In the Modeling ribbon at the top, there are options for formatting the field.  Make sure the data type is a decimal number, and then you can select a number of decimal places to show. Change it from Auto to 2.

Formatting.png

View solution in original post

2 REPLIES 2
Cmcmahan
Resident Rockstar
Resident Rockstar

Very possible.  In the Fields pane to the right, select the measure in question.

 

In the Modeling ribbon at the top, there are options for formatting the field.  Make sure the data type is a decimal number, and then you can select a number of decimal places to show. Change it from Auto to 2.

Formatting.png

I figured out what I was doing wrong.....

I tried to change the number format, but it never gave me the option to change it. 

Figured out that I had the card selected, and not actually the measure under fields. 

 

Thanks for your help!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.