Forum Discussion
Solved
POWERBI , How to return Multiple values from a column based on condition and plot it on line chart
I have table SrNO PersonType Allocation 1 Adult 1 2 Adult 2 3 Children 2 4 Unborn 2 Now I want to show in Line chart With 4 legend Adult Children Individual( it...
To solve this I have create 4 measure
VAR SummaryTable =
SUMMARIZE('t',
'Allocation'[Allocation],
"Adults",
CALCULATE (
COUNTROWS ( 'Allocation' )
,'Allocation'[PersonType] IN { "Adult"}
)
)
RETURN
SUMX ( SummaryTable, [Adults] )
Similarly created for other and Plot them in LIne Chart in Y axis .
To solve this I have create 4 measure
VAR SummaryTable =
SUMMARIZE('t',
'Allocation'[Allocation],
"Adults",
CALCULATE (
COUNTROWS ( 'Allocation' )
,'Allocation'[PersonType] IN { "Adult"}
)
)
RETURN
SUMX ( SummaryTable, [Adults] )
Similarly created for other and Plot them in LIne Chart in Y axis .