Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Can someone help me out with what I need to do to make this formula to work? I dont understand the error?
Below is part of the original formula.
Hi @jonnyA ,
Believe that by the error you are showing that you are creating a measure when doing that you need to do an aggregation that is why it's not working.
Try to use the same formula but as a column.
Just one additional tip on DAX you should always refer the measures and columns accordingly to the notation below:
Column - Table[ColumnName]
Measure - [MeasureName]
If you do it like this you will identify faster the use of measures or columns in your formulas.
If I have misunderstood your meaning, please provide your pbix file without privacy information and your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@jonnyA , Seem like you are using the dataset that has some problem. Publish it again and check. I think one measure is missing.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
86 | |
68 | |
64 | |
63 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |