Display count value in card for conditional data.

[Anonymous]

Hello, 

Working with data set similar to below image, Want to displayed count of suppliers whose score >= 0.6 & < 60 and it should be updated with Filter value of Time Horizon.



For that try to create mesure, 

Low Agility Suppliers = 

var Horizon = SELECTEDVALUE(Orders[Due date Time Horizon])

Return 

IF(Horizon = "Forecasted",
 IF(ISBLANK(CALCULATE(
             DISTINCTCOUNT(Orders[supplier]),
                  FILTER(Orders,[Agility Score] < 0.6 && Orders[Due date Time Horizon]="Forecasted"))),
            0,CALCULATE(DISTINCTCOUNT(Orders[supplier]), 
                  FILTER(Orders,[Agility Score] < 0.6 && Orders[Due date Time Horizon]="Forecasted"))),

 IF(ISBLANK(CALCULATE(
             DISTINCTCOUNT(Orders[supplier]),
                FILTER(Orders,[Agility Score] < 0.6 && Orders[Due date Time Horizon]="Historical"))),
           0,CALCULATE(DISTINCTCOUNT(Orders[supplier]),
                FILTER(Orders,[Agility Score] < 0.6 && Orders[Due date Time Horizon]="Historical"))
))

Same for the High value supplier with change value >=0.6 
Displayed both value in card but total of both value are greater than total supplier in data set.

[amitchandak · Accepted solution]

@Anonymous , Not sure what is measure for <60. You have to try a measure like

countx(filter(Summarize(Table, Table[Supplier], "_1",[Agility Score] , "_2", sum(Table[Ordered Delivered])),[_1] >=.6 && [_2] <60),[Supplier])

[Anonymous]

Hello @amitchandak ,

Thanks for the reply, 
I have to displayed summarized result as table (Matrix), Score values between 0 to 1.
which calculated working fine.
Now, 
I want to displayed Card of Total number or supplieres whom score >= 0.6. and in another card for < 0.6 
In filter Selecting if select any new buyer whom dont have any supplier yet so that time displayed blank so replace blank value with 0 I tried this.

Low Agility suppliers= 

 IF(ISBLANK(CALCULATE(DISTINCTCOUNT(Orders[supplier]),FILTER(Orders,[Agility Score] < 0.6))),

 0,CALCULATE(DISTINCTCOUNT(Orders[supplier]),FILTER(Orders,[Agility Score] < 0.6))

High Agility suppliers= 

 IF(ISBLANK(CALCULATE(DISTINCTCOUNT(Orders[supplier]),FILTER(Orders,[Agility Score] >= 0.6))),

 0,CALCULATE(DISTINCTCOUNT(Orders[supplier]),FILTER(Orders,[Agility Score] >= 0.6))

The total of both card should be equel to total unique supplier name count.
But the total of both card grater than total unique suppliers value.