Forum Discussion
New measure or column ?
- 7 years ago
Ok, I have a feeling that the measures are correct, but I suspect you are getting the results you see because, given the 150,000 + rows of tests, and given that you carry out 230 individual tests, if you analyse the whole dataset you are finding that all tests have been carried out at some stage, and none of the tests have never "not been carried out".
150,000 rows / 230 tests = 652 rows / test (on average)!!
That is, If I am understanding what your are trying to achieve (as per your original post).
What I suggest you try is to add a slicer to your page (year for example) and play around to see if the values change.
I have tried it in my sample and the measures return what I am expecting. I have changed one of the measures to the below to allow for the slicer to work (changed the ALL in the filter to ALLSELECTED):
Unique Tests Not Executed EVER = VAR calc = CALCULATETABLE(VALUES(Sales[Product]); FILTER(ALLSELECTED(Sales); [Not Executed (at some stage)]=0)) VAR full = VALUES(Sales[Product])
Return COUNTROWS( EXCEPT(full; calc))Here is an example if I filter my sample data to see only rows for 2018 (which you can compare to the image I posted in the above post):
But there again I may have misundestood what you are actually trying to achieve!
Hi Mous007
You can perform this calculation with a measure. The formula will be similar to this;
Measure = calculate(count(tests),or(valid1="-",valid2="-"))
Let me know if this helps you :)
Thanks,
George
Thankss for ur reply George but unfortunatly the formula is returning
The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression
- judspud7 years ago
Solution Supplier
Apologies,
In that case please try the following as a column;
Column = if(or(Validity1 = "-", Validity2 = "-",1,0)
You can then sum the column in a card visual :)
Thanks,
George