Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
shri0025
Helper II
Helper II

City wise total and % of Total

Hi   team 

Please Help  me Create DAX  Total  city qty   and % total Item    if  Filter Cust A than  Out come    Total QTY 10   than % of Total  20% 40% 40%   example below in table

 

CustCityStateItemQTY
AAGRAUP1a2
AAGRAUP2a4
AAGRAUP2a4
BMathuraUP1a3
BMathuraUP2a3
BMathuraUP2a3
CINDOREMP2a2
CINDOREMP1a2

 

 1 Out put if fitered  Cust A  Than Total  QTY  Cust total qty  and % total QTY cust A Based 

 

 

CustCityStateItemQTYDAX  Total QTY City wise% Total QTYIf Filter Cust A  Than  Total QTYIf Filter Cust A  Than  % Total QTY
AAGRAUP1a2258%1020%
AAGRAUP2a42516%1040%
AAGRAUP2a42516%1040%
DAGRAUP1a32512%  
DAGRAUP2a52520%  
DAGRAUP2a72528%  
BMathuraUP1a3933%  
BMathuraUP2a3933%  
BMathuraUP2a3933%  
CINDOREMP2a2450%  
CINDOREMP1a2450%  

 

1 REPLY 1
lbendlin
Super User
Super User

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.