Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Display count value in card for conditional data.

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...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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.