Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Aggregated Value in KPI

Hello!   I would like to develop some KPI visuals that shows both the breakdown each month, and the entire calculation as a number (like a card). I'd like to essentially combine a card visual with ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try Like

     


    measure =
    divide(COUNTX(filter(Values(Table[month]), Table[Value]>=200),CALCULATE(sum(Table[Value]))),CALCULATE(COUNT(Value)))

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

Anonymous , Try Like

 


measure =
divide(COUNTX(filter(Values(Table[month]), Table[Value]>=200),CALCULATE(sum(Table[Value]))),CALCULATE(COUNT(Value)))