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 am having issue crafting a measure to display the total number of records based on a measure displayed in a Table. I would have thought this was easy, especially after seeing This Thread. However, my calculation is not coming out with the correct value.
Below is the data being displayed based on selected filters and relationships. It is properly displaying the expected ID's and it has the proper results for the Fix Attempts Measure. I am trying to get the total number of records that had Fix Attempts = 1. As you can see my calculation is not giving the correct result. If I set a visual Level filter for Fix Attempts =1, the rows that should make up the calculation are properly displayed.
Here is my measure
With 1 Fix =
CALCULATE(
DISTINCTCOUNT(Bugs[WorkItemId]),
FILTER(Bugs,Bugs[Fix Attempts]=1))
Here is the measure total, for the below data, which is off.
Data Table (all coming from table - Bugs)
Data filtered with Visual level filter, that shows my measure result should be 9, for the data displayed
Solved! Go to Solution.
Hi,
Try this measure
With 1 Fix = CALCULATE(DISTINCTCOUNT(Bugs[WorkItemId]),FILTER(values(bugs[id]),[Fix Attempts]=1))
Hey @EaglesFly123 ,
try the following measure:
With 1 Fix =
CALCULATE(
DISTINCTCOUNT( Bugs[WorkItemId] ),
Bugs[Fix Attempts] = 1
)
HI @selimovd
When I do that, I get an error - A function 'CALCULATE' has been involved in a True/False expression that is used as a filter expression. This is not allowed.
Hi,
Try this measure
With 1 Fix = CALCULATE(DISTINCTCOUNT(Bugs[WorkItemId]),FILTER(values(bugs[id]),[Fix Attempts]=1))
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |