Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table where I have Column field %Accuracy.
The values are coming as below, I need to calculate the total of ACCURATE in the Summary (Top of the Column)
% Accuracy |
---|
- |
ACCURATE |
ACCURATE |
ACCURATE |
ACCURATE |
ACCURATE |
ACCURATE |
ACCURATE |
ACCURATE |
ACCURATE |
ACCURATE |
ACCURATE |
ACCURATE |
ACCURATE |
ACCURATE |
ACCURATE |
ACCURATE |
ACCURATE |
ACCURATE |
ACCURATE |
ACCURATE |
ACCURATE |
My expression is: =Only([BSMP13 Accurate/Non Accurate])
What is the expected output here? 100%? Since everything is ACCURATE?
Yes. That's correct.
May be try this
If(Dimensionality() = 0, Num(Count({<[BSMP13 Accurate/Non Accurate] = {'ACCURATE'}>}[BSMP13 Accurate/Non Accurate])/Count([BSMP13 Accurate/Non Accurate]), '##%'), Only([BSMP13 Accurate/Non Accurate]))
If all 'Accurate' is should show 100%, if some values are "Not Accurate" it should calculate accordingly.
Try this and it should work, I think
If(Dimensionality() = 0, Num(Count({<[BSMP13 Accurate/Non Accurate] = {'ACCURATE'}>}[BSMP13 Accurate/Non Accurate])/Count([BSMP13 Accurate/Non Accurate]), '##%'), Only([BSMP13 Accurate/Non Accurate]))
It is working but in some of the months all values are accurate but it shows 94%.
Do you have a calculated dimension? Would you be able to share a screenshot to check this out?
Yes. I can show you the issue.
Difficult to say why it is doing that? Calculated dimension? Can you share a sample?