Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

If Condition

Hello All,   Iwas using IF condition to calculate based on condition.   While applying formula i could not able to select the comlumn name to filter the data. fpr example I've a table with column...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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