Forum Discussion
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 ...
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.
vanessafvg Here you have a link of my One drive with the example :
https://drive.google.com/open?id=1YPPLH11N7Q7_tjsrNaSrQk4zSPNbRB2O
As you can see in the two first tables , there is showing more dates that I have in my dataset. I hope you can help me with this example.
Thanks in Advance
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.