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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vjnvinod
Impactful Individual
Impactful Individual

Total in the Table visual

Hi,

 

i have a table visual(see below), where i have 2 coloumn Gter and Margin, see below

what i want to do is show the total of GTER coloumn only, not margin total

 

how do i do that?

 

Capture.PNG

1 ACCEPTED SOLUTION
vjnvinod
Impactful Individual
Impactful Individual

@mahoneypat @amitchandak 

 

please ignore, i figured it out, i just had to push the coloumn to "Dont summarize" and it resolved the issue

View solution in original post

3 REPLIES 3
mahoneypat
Employee
Employee

You will need to add a condition to your margin measure to prevent a result in the "total" row.  You didn't show the column(s) in your table but you need something like this.

 

Account Margin % YTD = IF(HASONEVALUE(Table[Column]), [Account Margin % YTD])

 

This will return blank in the total row.  Replace Table[Column] with one of the columns in your table.  Also, you can reference your existing margin measure as shown, or just wrap your current expression with the IF(HASONEVALUE ....).

 

Regards,

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


vjnvinod
Impactful Individual
Impactful Individual

@mahoneypat  @amitchandak 

 

Note: Account Margin % YTD is a coloumn and not measure.

so the below formula you have provided doesn't works, i tried and its showing me everything blank

vjnvinod
Impactful Individual
Impactful Individual

@mahoneypat @amitchandak 

 

please ignore, i figured it out, i just had to push the coloumn to "Dont summarize" and it resolved the issue

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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