Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Problem with some data in table or graphs

Hi all,       AS you can see yellow part of the imagen, In my dataset, I have data from Jnin the imagen I have some data for two clients each client have different data for example. Client ...
  • vanessafvg's avatar
    vanessafvg
    7 years ago

    Anonymous   i see what the problem is but i dont quite understand what is happening

    I changed the calculation slightly

    NS content_ok2 = divide(CALCULATE(count(test[content_ok]),'test'[content_ok]= "NO"),calculate(count(test[content_ok])))
     
    the problem is this 1- divide(CALCULATE(count(test[content_ok]),'test'[content_ok]= "NO"),calculate(count(test[content_ok])))
     
    the 1- brings back all the dates for that year.