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 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.

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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super 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.