Dax showing wrong value

Question

Hello All,&nbsp;&nbsp;I have some query regard dax i use dax but showing wrong value on my card visual&nbsp;first measure is need to count how many time my name is apper on firstname column if 5 time show me value 5&nbsp;Number of Leasing Agents =CALCULATE(&nbsp; &nbsp; COUNTROWS(&nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUES('J Turner Dashboard'[First Name]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'J Turner Dashboard'[First Name] &lt;&gt; BLANK()&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; ),&nbsp; &nbsp; ALLEXCEPT('J Turner dashboard', 'J Turner Dashboard'[Property], 'J Turner Dashboard'[Month1],'J Turner Dashboard'[YearPart]))so my need with this 2nd measure that i need count row after i filterd by month and property and year so i check manually but count is showing wrong even i use dax studio but showing incorrect value&nbsp;2nd measure&nbsp;Number of Prospect Survey Score =CALCULATE(&nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; VALUES('J Turner Dashboard'[First Name]),&nbsp; &nbsp; &nbsp; &nbsp; IF(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NOT(ISBLANK('J Turner Dashboard'[First Name])),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; ),&nbsp; &nbsp; ALLEXCEPT('J Turner dashboard', 'J Turner Dashboard'[Property], 'J Turner Dashboard'[Month1],'J Turner Dashboard'[YearPart]))and 3 measure&nbsp;TotalPropertyIndex_Filtered. =CALCULATE(&nbsp; &nbsp; AVERAGE('J Turner dashboard'[Property Index]),&nbsp; &nbsp; ALLEXCEPT('J Turner dashboard', 'J Turner Dashboard'[Property], 'J Turner Dashboard'[Month1])) i want avrage from propertyindex column&nbsp;can i get help from anyone to fix this measure&nbsp;take&nbsp; a look screnshot j turner showing 8 and 8.43 this 2 card showing wrong value i check manually in data view its only 6 and 8.33 and also look in matrix value show me wrong count there are only 6 agent and agent has 4 time name and 2 agent has 1 time but matrix value show wrong count&nbsp;&nbsp;&nbsp;

lbendlin · Answer

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to 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.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

anonymous · Answer

Assuming i've understand what you are trying to achieve, i'd suggest first you need to split your base aggreations into their own measures, then use a calculate statement to call that base measure with the added context to achieve your aims.&nbsp; I think what you are trying to achieve is this:Name Count = COUNT('J Turner Dashboard'[First Name])(Count function ignores blanks)Row Count = COUNTROWS('J Turner Dashboard')Avg Property Index = AVERAGE('J Turner dashboard'[Property Index])Number of Leasing Agents = CALCULATE(
	[Name Count],
	ALLEXCEPT('J Turner dashboard', 'J Turner Dashboard'[Property], 'J Turner Dashboard'[Month1],'J Turner Dashboard'[YearPart])
)Number of Prospect Survey Score = CALCULATE(
	[Row Count],
	ALLEXCEPT('J Turner dashboard', 'J Turner Dashboard'[Property], 'J Turner Dashboard'[Month1],'J Turner Dashboard'[YearPart]),
	NOT ISBLANK('J Turner Dashboard'[First Name])
)TotalPropertyIndex_Filtered = CALCULATE(
	[Avg Property Index],
	ALLEXCEPT('J Turner dashboard', 'J Turner Dashboard'[Property], 'J Turner Dashboard'[Month1],'J Turner Dashboard'[YearPart]),
	NOT ISBLANK('J Turner Dashboard'[First Name])
)(I added the non-blank to the average calculation to ignore the same rows as the other measures)

x0 · Answer

Hello&nbsp;Anonymous&nbsp;&nbsp;Please have a look after trying your approach&nbsp;and this is original&nbsp;help me out for accurate result.&nbsp;

anonymous · Answer

Seems like you want a distinct count instead of a regular count. Change the measure to be this:Name Count = DISTINCTCOUNT('J Turner Dashboard'[First Name])&nbsp;

x0 · Answer

Hello&nbsp;Anonymous&nbsp;&nbsp;I want filtered row count which is 6 , hey one more thing i noticed my custom table that i created dynamically maybe problem is from that dax&nbsp;CustomTable =FILTER(&nbsp; &nbsp; DISTINCT(&nbsp; &nbsp; &nbsp; &nbsp; UNION(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTCOLUMNS('Conversion', "LeasingAgent", LOWER('Conversion'[Leasing Agent]), "Property", 'Conversion'[Property], "Month1", 'Conversion'[Month1], "Year", 'Conversion'[YearPart], "MonthIndex", 'Conversion'[MonthIndex], "First Name", 'Conversion'[First Name]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTCOLUMNS('Move Insq', "LeasingAgent", LOWER('Move Insq'[Leasing Agent]), "Property", 'Move Insq'[Property], "Month1", 'Move Insq'[Month1], "Year", 'Move Insq'[YearPart], "MonthIndex", 'Move Insq'[MonthIndex], "First Name", 'Move Insq'[First Name]),SELECTCOLUMNS('Query1', "LeasingAgent", BLANK(), "Property", 'Query1'[Property], "Month1", 'Query1'[Month1], "Year", 'Query1'[Year], "MonthIndex", 'Query1'[MonthIndex], "First Name", BLANK()),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTCOLUMNS('J Turner Dashboard', "LeasingAgent", LOWER('J Turner Dashboard'[Leasing Agent]), "Property", 'J Turner Dashboard'[Property], "Month1", 'J Turner Dashboard'[Month1], "Year", 'J Turner Dashboard'[YearPart], "MonthIndex", 'J Turner Dashboard'[MonthIndex], "First Name", 'J Turner Dashboard'[First Name]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTCOLUMNS('Online Review', "LeasingAgent", BLANK(), "Property", 'Online Review'[Property], "Month1", 'Online Review'[Month1], "Year", 'Online Review'[Year], "MonthIndex", 'Online Review'[MonthIndex], "First Name", BLANK()),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTCOLUMNS('Shop Report Tracker (2)', "LeasingAgent", LOWER('Shop Report Tracker (2)'[First Name.]), "Property", 'Shop Report Tracker (2)'[Property], "Month1", 'Shop Report Tracker (2)'[Month1], "Year", 'Shop Report Tracker (2)'[Year], "MonthIndex", 'Shop Report Tracker (2)'[MonthIndex], "First Name", 'Shop Report Tracker (2)'[First Name.])&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; ),&nbsp; &nbsp; NOT(ISBLANK([LeasingAgent])))this is i created for filter my data by first name , property and , month/yearbecause i noticed that provided dax from you if i use using j turner table property , first name and month showing correct value also i have doubght on relationship part, can you help me with this almost we are close to finish this error.&nbsp;&nbsp;&nbsp;maybe my custom table getting distic value or something else because result is wrong on other table as well .&nbsp;

Forum Discussion

Dax showing wrong value

6 Replies

Related content

Date Different return wrong value

Totals showing wrong value

wrong Month values showing

Average Overdue days showing wrong values (Power BI)

Matrix showing wrong values