Forum Discussion

POSPOS's avatar
POSPOS
Post Partisan
2 years ago

Incorrect Values in Scatter Plot

Hi All, I have a requirement to show the count of ID as lables in Scatter Plot. I have created a column for the same but the values are not working as expected. The expected result for dept 2 is 2 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi POSPOS ,
Create a column under Owner table

Count of department = 
CALCULATE(
    COUNT('ID'[Count of ID]),
    FILTER(
        ALLEXCEPT(
            'ID',
            'ID'[Dept]
        ),
        'ID'[Appointment Date]>= DATE(2022,07,01)
    )
)

Create a column under Sal table

Count = 
CALCULATE(
    MIN(Owner[Count of department]),
    ALLEXCEPT(
        Sal,
        Sal[Dept]
    )
)

Final output

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

POSPOS's avatar
POSPOS
Post Partisan
2 years ago

Hi Anonymous  - I tried to replicate the same in the original report and I get same values for all the departments