Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm attempting to create a measure to divide one card by another.
Services Count / Services Goal = Percent to Goal
PTG Northstar =
DIVIDE(
CALCULATE(
COUNTROWS(CareerCenterGoals)
,CareerCenterGoals[Count of activityID -0 instead of blank]
)
,CALCULATE(
COUNTROWS('Goals: Career Center')
,'Goals: Career Center'[Services Goal]
)
)
I recieved this error: A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.
Hi @dave24meyers ,
According to your description, the highlight part of your DAX code bellow hasn’t express what outcome you want, it should be an expression but not a column.
If you want to calculate the count of rows which is not blank, you can use the following measure.
Here’s some information which may help you to understand.
https://docs.microsoft.com/en-us/dax/calculate-function-dax
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have measure 1 which counts number of cells and returns "0" instead of blank.
I have measure 2 which is divisional goal.
I'm attempting to create measure 3 to show me percent of goal. The two measures divided by each other.
@dave24meyers So generally that should look something like:
PTG Northstar =
DIVIDE(
CALCULATE(
COUNTROWS(CareerCenterGoals)
,CareerCenterGoals[Count of activityID -0 instead of blank] = <some value>
)
,CALCULATE(
COUNTROWS('Goals: Career Center')
,'Goals: Career Center'[Services Goal] = <some value>
)
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |