Total & Part Stacked Column Graph

[Anonymous]

How do I create a stacked column graph, such that 25 total from one field, n of which are have some characteristic from another field are shown in one column where the top is at 25 not 25+n? Do I have to calculate a, 25 - n, field? If so, where can I get a quick intro/review of calculated fields basics so I understand how that works in the Power BI data view? (Should I move this question to the Dax forum?)

I think this requires only 2 columns for illustraction, ID and Over SLA. I want a column with TOTAL ID count and how many of them have OVER SLA = 1.

ID	Over SLA
1265	1
1850	1
1930	1
1942	1
1893	1
2105	1
2177	1
2204	1
2223	1
2313	1
2370	1
2396	1
2459	1
2461	1
2489	1
2500	1
2502	1
2507	1
2521	1
2523	1
2524	1
2526	1
2530	1
2531	1
2536	1
2539	1
2540	1
2542	1
2552	1
2558	1
2577	1
2580	1
2581	1
2584	1
2586	1
2587	1
2588	1
2589	1
2590	1
2595	1
2598	1
2600	1
2601	1
2607	1
2614	1
2616	1
2620	1
2621	1
2622	1
2624	1
2603	0
2626	1
2629	1
2631	1
2636	1
2637	1
2639	1
2640	1
2642	1
2643	1
2647	1
2650	1
2651	1
2652	1
2656	1
2658	1
2659	1
2660	1
2661	1
2662	1
2663	1
2665	1
2666	1
2667	1
2668	1
2669	1
2670	1
2671	1
2672	1
2673	1
2674	1
2675	1
2676	1
2677	1
2678	1
2679	1
2680	1
2681	1
2682	1
2683	1
2684	1
2685	1
2686	1
2687	1
2688	1

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous]

Hi Ashish,

Thank you, but I have an older version of PowerBI. I can't see how to got these results. If you created a new calculated variable I couldn't see it.  

[Ashish_Mathur · Accepted solution]

You are welcome.  My solution will work in all versions.  I have written 2 measures to solve the question (you can see them in the Fields pane of the image in my previous message).