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.
Hello! I'm sure I'm just missing something simple here, because I haven't used measures in over a year (so I'm rusty!)
I'm just trying to create a measure that shows the rate of closed sales/total sales.
For Closed Sales I created a counta measure
Nobody will be able to tell you what's wrong until you describe to us what the calculation should mean and how your data is structured. But you can try to diagnose this problem yourself. All you have to do is display the components from which your % is calculated. So, display this PCloseRateM = COUNTA('Proposals Paste'[ID]) and display this PSaleRateM = COUNTA('Stats, Sales, Loss, Etc'[Actual Sales Monthly]). You'll then see both the components and it'll be easier, I guess, to see why your division is the way it is. By the way, I can't see a reason you'd use COUNTA. Isn't it better to use COUNTROWS?
Hi @slan2018 ,
Yu can try this
CloseM =
VAR PCloseRateM =
COUNTROWS ( 'Proposals Paste' )
VAR PSaleRateM =
COUNTROWS ( 'Stats, Sales, Loss, Etc' )
RETURN
DIVIDE (
PCloseRateM,
PSaleRateM
)
Else pls share some sample data and expected output.
Regards,
Harsh Nathani
@slan2018 - Wondering if perhaps you need an ALL clause in your measure, but hard to tell. Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
71 | |
36 | |
21 | |
19 | |
15 |
User | Count |
---|---|
125 | |
37 | |
29 | |
29 | |
24 |