Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have used the below formula for removing the Subtotals. But for Company with single row the subtotal is not removing.
Similarly for the CAP_TYPE column if 2 rows has large then the TOTAL is large. it should be empty.
Formula for removing Sub_Total is
Solved! Go to Solution.
Hi @Anonymous ,
Please create the measures as below to work on it.
A = IF([M_CAP TYPE] = "Large",1,0)
A1 = SUMX('Merge2-Used for Earnings Monitor Tbale Format',[A])
A2 = IF(ISINSCOPE('Merge2-Used for Earnings Monitor Tbale Format'[CONAME]),[M_CAP TYPE],IF([A1]>=2,"Large",BLANK()))
Hi @Anonymous ,
Please create the measures as below to work on it.
A = IF([M_CAP TYPE] = "Large",1,0)
A1 = SUMX('Merge2-Used for Earnings Monitor Tbale Format',[A])
A2 = IF(ISINSCOPE('Merge2-Used for Earnings Monitor Tbale Format'[CONAME]),[M_CAP TYPE],IF([A1]>=2,"Large",BLANK()))
Hi @Anonymous ,
If and ISINCOPE function should help you in your scenario. Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
here is the link for .pbix file
https://drive.google.com/file/d/1F6XPTchbhf95m53V-nObyVHC6leL0UTJ/view?usp=drivesdk
@Anonymous Please select matrix click on format pane and turn off the row subtotal option
@Anonymous i need Subtotal for limited column. so that is why i am removing subtotal for the columns which i needed.
@Anonymous
use "table" instead of "Matrix" (from the visualization pane)
if the data is loaded like this, then use power query and remove those rows
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |