Forum Discussion
Measure total wrong
- Yes,its measure total problem. When I added if( hasonefilter (table1[field1) at the front of created measure, total row goes away. For now I am okwith that
You had a number of syntax issues and spelling errors for functions. Try this:
measure =
CALCULATE(
DATEDIFF(
FIRSTDATE( table1[field1] ),
LASTDATE( table2[field2] ),
DAY
),
USERELATIONSHIP ( table2[field3], table1[field4] )
)
It may still not work and provide the results you want, but it is, at least, syntactically correct.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
I have no idea then. You'll have to provide data, and the expected result, for anyone to tell you why your measure isn't working.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI ForumThis looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907- Yes,its measure total problem. When I added if( hasonefilter (table1[field1) at the front of created measure, total row goes away. For now I am okwith that
