total measure is incorrect

[avivbnbn24]

total measure is incorrect

yesterday

Hi, I have created a measure based on other measures and when I use it in a table visual the total is incorrect. 

this is the Dax: 

total_reward = SWITCH(true(),

[% target] < 1 , ([issued]*10)+([transfer]*10)+([linkage to wallet]*10),

[% target] < 2 , ([issued]*30)+([transfer]*15)+([linkage to wallet]*10),

([issued]*40)+([transfer]*20)+([linkage to wallet]*10)).

actually, the total is a calculation of the total row and not some of the column

please help me out here 

thanks

[Anonymous · Accepted solution]

Hi @avivbnbn24  ,

Please create another new measure as below and replace the original measure [total_reward] on the matrix:

Measure = SUMX ( VALUES ( 'Table'[CATEGORY COLUMN IN VISUAL] ), [total_reward] )

In addition, you can refer the following links to try to solve your problem...

Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand

Dax for Power BI: Fixing Incorrect Measure Totals

If the above ones can't help you figure out, please provide some raw data in your tables(exclude sensitive data) with Text format and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[avivbnbn24]

I've chosen a column for unique rows but still get the wrong number in the total. I have a table with id`s and rewards for each id.  what can be the problem? 

[BeaBF]

@avivbnbn24 can you paste some sample data? on which you calculate the measure and the measures. 

[avivbnbn24]

issued = sum(fact_issued[num_issued])

transfer = sum(fact_transfer[ISSUED CNT])

linkage to wallet = sum(fact_issued[linkage])

target = DIVIDE(CALCULATE([issued],ALLEXCEPT(dim_emp,dim_emp[branch num]),REMOVEFILTERS(fact_issued[DWH DIM CARDS DATA SOURCE.DATA SOURCE])),[week target])

week target = 

IF(

    MAX('date valid'[week num]) = 24,

    MAX(dim_emp[target week 24]),

    MAX(dim_emp[week targets])

)

[BeaBF]

@avivbnbn24  can you also paste some sample data to use?

BBF

[avivbnbn24]

what do you mean by pasting some sample data? in which way? the screen shot isn't enough?

[foodd]

Hello @avivbnbn24 , when @BeaBF asked that you please share your work-in-progress Power BI Desktop file (with sensitive information removed) and any source files in Excel format that fully address your issue or question in a usable format (not as a screenshot). You can upload these files to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then provide the file's URL.  Screenshots rarely are successful communicators when working through a Forum Question.

This dovetails to the guardrails of the Community Forum outlined below:

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!

[BeaBF]

@avivbnbn24 Hi!

Try with:
total_reward =
SUMX(
VALUES('your_table'[<column_for_unique_rows>]),
SWITCH(
true(),
[% target] < 1 , ([issued]*10)+([transfer]*10)+([linkage to wallet]*10),
[% target] < 2 , ([issued]*30)+([transfer]*15)+([linkage to wallet]*10),
([issued]*40)+([transfer]*20)+([linkage to wallet]*10)
)
)