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,

Does this measure work?

=IF(HASONEVALUE(Table[Type]),If(VALUES(Table[Type])="Bundle",(distinctcountmeasure), (sumof Bundle measure)),BLANK())

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello Ashish,

 

I dint get any value.

 

REgards

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

    Share the link from where i can download your PBI file.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello Ashish,

       

      I could able to share sample data which is similar to my data. 

       

      I've data from fy14 till date and month is recorded as first day of the month pattern.

      've client with size, if you abservve the client 3 whihc is a bundled type implies has say 500 clients (from columnH), my req is if i need the count for each month Client1,client2, client4 should display as 1 but for client3 it should count as 500 for month of April and 505 in May any dynamically change monthly.

       

      Please let me know if you need further details.

       

      https://drive.google.com/file/d/1BAfwWWw-_caH8VQXl_l3h1nckvfQ_WjI/view?usp=sharing 

       

      REgards

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        Hi,

        You may download my PBI file from here.

        Hope this helps.