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.
Hi all,
Imagine a table like this:
I want a calculated column to divide a fixed number (In this example 20) with the Count of Job ID's per Project ID.
In above example :
Project ID 1 has 4 distinct Job IDs. Therefore each Job ID is 5 (20 / 4)
Project ID 2 has 8 distinct Job IDs. Therefore each Job ID is 2.5 (20 / 😎
How do I achieve that?
Solved! Go to Solution.
@PeterStuhr Try this measure:
MEASURE =
VAR perJOB_ = CALCULATE(COUNT(Table[Job ID],ALLEXCEPT(TableName,ProjectID))
RETURN DIVIDE(20,perJOB_)
@PeterStuhr , Check the screen shot of your scenario:
@PeterStuhr , Check the screen shot of your scenario:
@PeterStuhr Try this measure:
MEASURE =
VAR perJOB_ = CALCULATE(COUNT(Table[Job ID],ALLEXCEPT(TableName,ProjectID))
RETURN DIVIDE(20,perJOB_)
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
85 | |
65 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |