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.
i have created this measure
Solved! Go to Solution.
Hi @yves007
This seems to be the only solution.
Also, I use it regularly, so it has to work.
Here's an example I gave you. Let's try to figure out where things went wrong.
In any case, you can download a sample file from here in addition to the explanation below: Link to file
Using a sample file with a table, I built a small table for selecting metrics.
I have just built 3 measures for logical numeric results in:
As I suggested, I wrapped your formula in a format function
Finally, I checked the results using a small kpis table in Slicer and on simple table.
It works perfectly.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @yves007
Put the desired result in a function
"format"
Depending on your needs, you can choose any format
Something like :
it didnt work, is there another way?
Hi @yves007
This seems to be the only solution.
Also, I use it regularly, so it has to work.
Here's an example I gave you. Let's try to figure out where things went wrong.
In any case, you can download a sample file from here in addition to the explanation below: Link to file
Using a sample file with a table, I built a small table for selecting metrics.
I have just built 3 measures for logical numeric results in:
As I suggested, I wrapped your formula in a format function
Finally, I checked the results using a small kpis table in Slicer and on simple table.
It works perfectly.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
User | Count |
---|---|
85 | |
75 | |
70 | |
69 | |
55 |
User | Count |
---|---|
98 | |
96 | |
92 | |
78 | |
70 |