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 trying to get a weighted conversion based off the total of a different measure.
'Measure' is taking the count of agent ID over 'Paid Leads', but I only need the total. Problem is 'Count of AgentID' is a different data set so it is not tied to the indicators of each line.
I need to use the total of 'Mesaure' divided by the total of 'Conversion' multiplied by each lines conversion to weight it appropriately.
Line 1 example: = (0.32 / 18.0%) * 24.1% = 43.5%
The goal would be to do that for each line.
Is there a way to do this?
HI @hsackman
Its Possible we can do.Below i mentioned the measures . You can this one . I put some refference name instead that one you can change respective measures.
Measure=Divide(Measure ,Sumx(Values(Categorycolumn),Conversion Measure)
Thanks
Thennarasu R
I can't seem to input the Categorycolumn, that too is a created measure/calculation. How do I do this?
@hsackman
Then in table visuals how measures are spilt .We have one column that u used in first column based on that column all measues values are spilt .
I dont know that one instead of that i said like Category whatever column you have mention over there.
Thanks,
Thennarasu R
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |