Forum Discussion
PORTION OF A WHOLE | PIE CHART
- 3 years ago
I agree with eliasayy's solution, below are some additional details but it's the same solution they've given.
Assuming you have a 1:M relationship from Matriculas to Treinamentos, one solution is to add measures to calculate both portions of the visual:
QTD. TREINAMENTO 1 = CALCULATE( COUNTROWS( FILTER( RELATEDTABLE('Treinamentos de Janiero'), 'Treinamentos de Janiero'[Treinamento - Nome] = "CNV" ) ) )MATRICULAS = COUNTROWS(Matriculas)MATRICULAS WITH NO TREINAMENTO 1 = [MATRICULAS] - [QTD. TREINAMENTO 1]Add both [QTD. TREINAMENTO 1] and [MATRICULAS WITH NO TREINAMENTO 1] to the visual's Values fields
Note that you will not be able to filter other visuals by selecting the two categories on this visual - if that's required, you'll need a more complex solution.
I agree with eliasayy's solution, below are some additional details but it's the same solution they've given.
Assuming you have a 1:M relationship from Matriculas to Treinamentos, one solution is to add measures to calculate both portions of the visual:
QTD. TREINAMENTO 1 =
CALCULATE(
COUNTROWS(
FILTER(
RELATEDTABLE('Treinamentos de Janiero'),
'Treinamentos de Janiero'[Treinamento - Nome] = "CNV"
)
)
)MATRICULAS = COUNTROWS(Matriculas)MATRICULAS WITH NO TREINAMENTO 1 = [MATRICULAS] - [QTD. TREINAMENTO 1]
Add both [QTD. TREINAMENTO 1] and [MATRICULAS WITH NO TREINAMENTO 1] to the visual's Values fields
Note that you will not be able to filter other visuals by selecting the two categories on this visual - if that's required, you'll need a more complex solution.
- weakneee3 years agoFrequent Visitor
Hi, andrewpirie,
Thank you so much! This is what I what wanted.
The other visuals I can work separately.Once again, thank you for taking your time to help me.