Forum Discussion

lnayak's avatar
lnayak
Frequent Visitor
4 years ago
Solved

Create a Measure to Count based on a condition

Hi,   So i have a PowerPivot and i need to create a Measure to count the values based on a specfic value that is in the column and also to count only items that fall under certian category. So basi...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Use below formula

    =calculate(count(EDE[Worker]),EDE[Max over Bill Rate?]="Bill Rate Over Max",EDE[Invoice Option]="Staffing")

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Use below formula

=calculate(count(EDE[Worker]),EDE[Max over Bill Rate?]="Bill Rate Over Max",EDE[Invoice Option]="Staffing")

lnayak's avatar
lnayak
Frequent Visitor
4 years ago

Thank you Vijay_A_Verma , this worked!