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,

Show me the exact result you are expecting.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello Ashish,

 

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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,

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello Ashish,

     

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