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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
JeanMariePBI
Helper I
Helper I

MEASURE TOTAL IS BLANK BUT SHOULD BE VALUE

Hello,  I have a measure that is based on an if statement and the row values from the measure return correctly but I need the total value of the column which is currently blank.  The column on the left is the measure which needs the total and the column on the right is from a calc column (can't use calc column for my purpose):

 

JeanMariePBI_0-1638993988322.png

 

The Dax for the Measure column on the left is as follows:

 

MY_SLIDER_1_RebatesPaid_NoSales = if([MY_SLIDER_1_LINE_REB_PAID] + [MY_SLIDER_1_LINE_VOL] =[MY_SLIDER_1_LINE_REB_PAID],[MY_SLIDER_1_LINE_REB_PAID])
 
Any help is greatly appreciated.  Thanks!
 
1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

Hi @JeanMariePBI ,

 

I think you want to return the total value of the measure, right? It is very common that the total value of the measure is incorrect.
You can solve it by creating a new measure.

New Measure=SUMX('Table',[MY_SLIDER_1_RebatesPaid_NoSales])

 

Put this new measure into the view, there should be a total value, try it.

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-stephen-msft
Community Support
Community Support

Hi @JeanMariePBI ,

 

I think you want to return the total value of the measure, right? It is very common that the total value of the measure is incorrect.
You can solve it by creating a new measure.

New Measure=SUMX('Table',[MY_SLIDER_1_RebatesPaid_NoSales])

 

Put this new measure into the view, there should be a total value, try it.

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Jeanxyz
Impactful Individual
Impactful Individual

What's your definition for measure [MY_SLIDER_1_LINE_REB_PAID] and [MY_SLIDER_1_LINE_VOL]? Is there some formula which only allows for one value?

bcdobbs
Community Champion
Community Champion

Can you provide the dax for the three measures that make up that one eg  [MY_SLIDER_1_LINE_REB_PAID].

 

Also what forms the rows of the matrix visual above?



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

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!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.