Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good afternoon,
Having an issue with MROUND.
I have a table with college courses, and would like to look at the FTE for each institution and course, how ever it doesn't seem to like "the value for FTE cannot be determined. Either the column doesn't exist, or there is not current row for this column"
So table would look something like this
Year | Institution | Qual | FTE | Gender |
2019/20 | 1 | Dip | 1 | 1 |
2020/21 | 3 | Cert | 0.5 | 2 |
2019/20 | 1 | First | 1 | 2 |
2020/21 | 3 | Cert | 1 | 1 |
2019/20 | 1 | First | 1 | 1 |
The measure was FTE Rounded = MROUND([FTE]),5)
So the output would look like
Year FTE FTE Rounded
2019/20 3 5
2020/21 1.5 0 (as less than 2.5, rounds down)
Any help greatly recieved.
not sure if i fully get your, please create a calculated table with this:
SumTable =
VAR _table =
ADDCOLUMNS(
VALUES( TableName[Year] ),
"FTE",
CALCULATE(SUM(TableName[FTE]))
)
RETURN
ADDCOLUMNS(
_table,
"FTE Rounded",
MROUND([FTE], 5)
)
i tried and it worked like this:
Thanks this works in a table, but doesn't work when adding in a slicer.
Say for example I needed a matrix in Gender by year with a larger dataset, and then want to filer by qualification
Filter = Dip
16/17 17/18 18/19 19/20 20/21
Male 222 (220) 256(255) 212(210) 248(250) 227(225)
Female 229 (230) 246(245) 232(230) 248(250) 207(205)
Would I need to add multiple columns in? In brackets is the rounded numbers, don't need to to displayed this way, but this is what should be pulling through rather than the whole number.
Thank you very much
you would need a measure like this:
measure =
VAR _sum = SUM(TableName[FTE])
RETURN
MROUND(_sum, 5)
with the sample data you provided in the original post and changing 5 to 2, it worked like this:
p.s. please consider @someone, if you seek further suggestions.
Perfect!! Thank you
@Suzie_Suze_Sue , this you need to create a new column
FTE Rounded = MROUND([FTE]),5)
The measure will be like
FTE Rounded =Sumx(Table, MROUND([FTE]),5) )
Thanks
I have tried this and get the error
The syntaxt for ') is incorrect. 9DAX(Sumx(Table, MROUND([FTE]),5) ))).
Try this:
FTE Rounded =Sumx(Table, MROUND([FTE],5) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |