Forum Discussion
Pie Chart filter that can be filtered
- Anonymous4 years ago
Hi atjt217 ,
According to your screenshot, Location and Organization are in two columns. So when you create a measure, they will in two different levels. As far as I know, Location and Organization should in same level. Here I suggest you to create a new calculated table with Location and Organization in same column to create the Pie chart.
Table 2 = VAR _TABLE1 = SELECTCOLUMNS('Table',"Selection",'Table'[Organization],"Requests",'Table'[Requests]) VAR _TABLE2 = SELECTCOLUMNS('Table',"Selection",'Table'[Location],"Requests",'Table'[Requests]) RETURN UNION(_TABLE1,_TABLE2)Dim table for slicer:
DimLocation = VALUES('Table'[Location])DimOrganition = VALUES('Table'[Organization])Measure:
Measure = VAR _Location = VALUES(DimLocation[Location]) VAR _Organition = VALUES(DimOrganition[Organization]) RETURN IF(MAX('Table 2'[Selection]) IN _Location || MAX('Table 2'[Selection]) IN _Organition, CALCULATE(SUM('Table 2'[Requests])))Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
atjt217
I believe this location and organization are two different columns right?
Yes they are
- Anonymous4 years agoNot applicable
Hi atjt217 ,
According to your screenshot, Location and Organization are in two columns. So when you create a measure, they will in two different levels. As far as I know, Location and Organization should in same level. Here I suggest you to create a new calculated table with Location and Organization in same column to create the Pie chart.
Table 2 = VAR _TABLE1 = SELECTCOLUMNS('Table',"Selection",'Table'[Organization],"Requests",'Table'[Requests]) VAR _TABLE2 = SELECTCOLUMNS('Table',"Selection",'Table'[Location],"Requests",'Table'[Requests]) RETURN UNION(_TABLE1,_TABLE2)Dim table for slicer:
DimLocation = VALUES('Table'[Location])DimOrganition = VALUES('Table'[Organization])Measure:
Measure = VAR _Location = VALUES(DimLocation[Location]) VAR _Organition = VALUES(DimOrganition[Organization]) RETURN IF(MAX('Table 2'[Selection]) IN _Location || MAX('Table 2'[Selection]) IN _Organition, CALCULATE(SUM('Table 2'[Requests])))Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.