If Condition

Hello Ashish,

Thanks for your response, but it has little bug.

When i was trying to calculate the count for each month based on category (below screenshot is from the PBXI file"

1. 've a fields under type as "Big-Size" the client counts are not captured from the point where the sum condition is applied since all the bundled clients are BigSize Clients.

2. the Row level sub total is not captured as showh above.

3. I wish to check the type level of reporting like Small, Big Size etc.. as per observation, when both the conditions are applied  

Regards,

Varun

Hi,

Show me the exact result you are expecting.

Hello Ashish,

as mentioned above format, need to present the count at category level.

Hi,

I just do not understand.  May be someone else will help you.

Hello Ashish,

My requirement is to find the client count for each month under each category,hence above is the table format which shows the client count for each month and undr each category.

you solution is really close but if you observe in the DAX and the table sample  report wich i posted in my previous table, it doesnt show the final count since when the If formula is calculating the counr of Bundles.

Please let me know if you need further details.

REgards,

Hi,

As i have requested earlier, can you please tell me the exact numeric result you are expecting so that once i re-write my DAX formula, i can cross check my result with yours.

Hello Ashish,

Thanx for your time It helped me to get my solution.