Hello all,
I have a table with 3 columns
Valid Test #
1 A 2
1 B 4
1 C 6
0 D 9
In my dashboard I can make the 3 desired measures, with a filter on Valid=1 and filter Test=A for first measure Test=B in second and Test=C in last one.
Now I want a percentage of the total next to the measure. For A=2/12 B=4/12 and C=6/12
The filters Valid and Test are only on these 3 measures and not on the whole dashboard.
How do I calculate this in a new %measure?
I don't know how to use a measure with filter together with a measure that has a different filter.
Thx in advance
percentage ( {your measure} for report ) might be what you are looking for.
I think you need to do something like:
percentage([Your Measure] for [Valid])
Then, as that will give you percentages for Valid = 0 (which by your description, you don't want/need), you can use some sort of conditional formatting to hide that total row.
Hope that helps,
Adam.