KPI card visual

Hi Ahbiswas 

I build a sample table.

I build a calculated column and two measures to have a test.

Column = CALCULATE(COUNT(User[ID]),ALLEXCEPT(User,User[ID]))/CALCULATE(COUNT(User[ID]),ALLSELECTED(User))

Measure1 = 
VAR _sel =
    ALLSELECTED ( 'User'[Statement] )
RETURN
    CALCULATE (
        COUNT ( User[ID] ),
        FILTER ( ALLSELECTED ( User ), User[Statement] IN _sel )
    )
        / CALCULATE ( COUNT ( User[ID] ), ALL ( User ) )

Measure 2 = CALCULATE(COUNT(User[ID]),FILTER(User,User[Statement]=MIN(User[Statement])))/CALCULATE(COUNT(User[ID]),ALL(User))

Result:

By default,column and measure2 will show Passpercentage without FailPercentage. Measure1is correct.

Select Fail/Pass, all results are correct.

Change Values in statement column to have a test.

We found the KPI with column and Measure2 show 2percentage/ zzzpercentage. Measure1 is correct. The result is related to the measure you use or KPI visual Trend axis will display the entire change, the indicator will display the value of the last point of trend axis(Pass,2,ZZZ) by default. 

If this relpy still couldn't help you solve your problem, please provide me with your data model and your calculate logic in calculated column. Or you can provide me with your pbix file by your Onedrive for Business.

You can download the pbix file from this link: KPI card visual

Best Regards,

Rico Zhou

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