Dax measure doesn’t return correct total value in all rows
Hi,
Created a measure as below:
Its giving me the correct values at filter context and total as well as shown below:
My expected outcome of this measure should be:
total 0.17 should be in all rows of DBName-point id(filter context) and not their individual values(for ex: INSE-1000 should have 0.17 instead of 0.12)
In order to achieve that,i created a measure as below:
But then it gives 0.155 in all rows rather than 0.17
To elaborate with another example:
Please find the below sample data link:
Below screenshot shows, dax measure ‘
I wrote a measure ‘Invoice Unit Rate test 3‘ as below to display the total of ‘Invoice Unit Rate test 2‘ in all rows:
But my result is as below:
Please advise!
PFA file here Financial Management -Tanvi Copy 3 (3) (2) – Copy.pbix
Hi, Created a measure as below: Its giving me the correct values at filter context and total as well as shown below: My expected outcome of this measure should be:total 0.17 should be in all rows of DBName-point id(filter context) and not their individual values(for ex: INSE-1000 should have 0.17 instead of 0.12) In order to achieve that,i created a measure as below: But then it gives 0.155 in all rows rather than 0.17To elaborate with another example:Please find the below sample data link:Sample data.xlsx Below screenshot shows, dax measure ‘Invoice Unit Rate test 2 ‘ total as 0.12620 Which is correct: I wrote a measure ‘Invoice Unit Rate test 3’ as below to display the total of ‘Invoice Unit Rate test 2’ in all rows: But my result is as below: I expect Invoice Unit Rate test 3 dax measure to show values as below: DBName-Point_IdInvoice Unit Rate test 2’Invoice Unit Rate test 3INSE-10010.110780.1262INSE-10040.141930.1262Total0.12620.1262 Please advise!PFA file here Financial Management -Tanvi Copy 3 (3) (2) – Copy.pbix@SergeiBaklan Read More
