Forum Discussion

rkgundabhat's avatar
rkgundabhat
Helper I
2 years ago
Solved

Percent Measure

Hello, I am working with a table with columns Item, _and sales. Somes of the items has 0 sales. I need a measure which I use to show in a data card which shows the percent of items with 0 sales for ...
Need Help
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, rkgundabhat 

     

    You can try the following methods.

    Measure = 
Var _N1=CALCULATE(COUNT('Table'[Item]),FILTER(ALLEXCEPT('Table','Table'[Department]),[Sales]=0))+0
Var _N2=CALCULATE(COUNT('Table'[Item]),ALLEXCEPT('Table','Table'[Department]))+0
Return
DIVIDE(_N1,_N2)

    Is this the result you expect? Please see the attached document.

     

    Best Regards,

    Community Support Team _Charlotte

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

     

rkgundabhat's avatar
rkgundabhat
Helper I
2 years ago

v-zhangti 

I apologize for the delay. Here is a sample data. Items are unique. What I want to do is to find out for any given department  what is percentage of items with 0 sales

Department ItemSales
Dept1P14
Dept1P25
Dept2P30
Dept2P44
Dept3P55
Dept3P60
Dept4P40
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Try these measures

S = sum(Data[sales])

S with 0 value = countrows(filter(values(Data[Item]),[s]=0))

All items = countrows(Data)

Create a slicer of Department and select one department.  Drag this measure to a card visual

P = divide([S with 0 value],[All items])

Hope this helps.