topic Re: total measure is incorrect in DAX Commands and Tips

total measure is incorrect

avivbnbn24 — Mon, 08 Jul 2024 06:06:00 GMT

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

Re: total measure is incorrect

BeaBF — Mon, 08 Jul 2024 10:08:21 GMT

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)
)
)

Re: total measure is incorrect

avivbnbn24 — Mon, 08 Jul 2024 11:21:09 GMT

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?

Re: total measure is incorrect

BeaBF — Mon, 08 Jul 2024 12:06:13 GMT

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

Re: total measure is incorrect

avivbnbn24 — Mon, 08 Jul 2024 12:43:00 GMT

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])

)

Re: total measure is incorrect

BeaBF — Mon, 08 Jul 2024 12:37:41 GMT

avivbnbn24 can you also paste some sample data to use?

BBF

Re: total measure is incorrect

avivbnbn24 — Mon, 08 Jul 2024 13:02:09 GMT

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

Re: total measure is incorrect

foodd — Mon, 08 Jul 2024 23:03:46 GMT

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-Forum/ba-p/963216

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/1447523/highlight/true#M607150

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!

Re: total measure is incorrect

Anonymous — Tue, 09 Jul 2024 10:01:49 GMT

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