Forum Discussion

RichardJ's avatar
RichardJ
Responsive Resident
3 years ago
Solved

DAX Measure for a COUNT function syntax

Hi, I'm using a parameter 'Target' to determine a Target   1 can be changed to a chosen value 2 updates with a status depending on whether the 'Actual' Values match the Target Values and generate...
Need Help
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    3 years ago
    Total Met Plan = 
var a = SUMMARIZE(Actuals_By_Location,Actuals_By_Location[Location],Actuals_By_Location[Week Number],"d",[Delta Status])
return countrows(filter(a,[d]="Met Plan"))
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    This measure works

    Total Met Plan = COUNTROWS(FILTER(GENERATE(VALUES(Actuals_By_Location[Location]),VALUES(Actuals_By_Location[Week Number])),[Delta From Plan]>=0))

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

This measure works

Total Met Plan = COUNTROWS(FILTER(GENERATE(VALUES(Actuals_By_Location[Location]),VALUES(Actuals_By_Location[Week Number])),[Delta From Plan]>=0))

Hope this helps.