Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How to write measure for counting rows based result produced by another measure

Hi all,


I stuck at a situation which seems quite challenging for me. Kindly enlighten your views.


I have 04 tables in my data model.

Table 1: Network Code Master: This is dimension table with Network Code details for eg: each code is in which state etc.

Table 2: Calendar: This is default calendar table

Table 3: Contains Target: Coloumns are: Network Code, Target Month, Type of Service (Free/Paid), Target No. of service (1 network code will appear 1 time per month)

Table 4: Contains Result: Coloumns are: Network Code, Result Month, Actual No. of Service (Total) (1 network code will appear 1 time per month)


I created measure for Total Target = by using calculate & filter function: Networkwise/ Monthwise total service volume (sum of paid & free service) from Table 3


I created another measure for Total result = by simpling using calculate sum of actual no. of service from Table 4


Another measure for Target Achieve No. = by dividing above 02 measure (result divide by target)


Now here is requirement. Now I want to count no. of dealers (network codes) achieved

100% & above result,


Below 80%

I will plot a tendency chart by month for the same.


NOTE: I can do it by adding calculated colomn however it is giving performance issue so solution should be related to DAX measure


Pls. advise

Super User IV
Super User IV

@ngour615 , Seem like you need to bucket a measure. This can be done with help from an independent table and new measure with a common group


Refer to my video on that




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Thanks @amitchandak , I read article written by you in link. Requirement is matching to my requirement. However it needs study at my end and then I can try to complete the same.

Let me study and I will try the same. After trying I will share findings. Also I will watch video soon (currently restrictions in company to open you tube). Will watch and then give it a try

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors