Forum Discussion
Solved
Need Help with Measure
Hi, I created a measure for Total sum value respective of each tag id within selected period. There i have column that compared Tag owner name and order owner name. Its resulting a string Used ...
Hi NavaneethaRaju ,
I have only created a simple sample, please refer to it to see if it helps you.
Create a measure to calculate total.
Measure = SUMX(ALL('Table'),'Table'[VALUE])And the measure will not be changed by slicer.
Then you can create measures based on the measure.
If I have still misunderstood your meaning, you can create simple data with excel, then show me the screenshots about the data and the desired output your want.
best regards.
Hi NavaneethaRaju ,
What is the data in Procedure Fact'[Procedures]? It seems you are using about 2 tables.
Please change the measure.
Total Procedures(Other Territory) =
SUMX (
ALL ( 'Tag Usage Fact'[Tag ID] ),
CALCULATE (
SUM ( 'Procedure Fact'[Procedures] ),
--ALLEXCEPT ( 'Account Dim', 'Account Dim'[Account ID] ),
ALLEXCEPT (
'Tag Usage Fact',
'Tag Usage Fact'[Tag ID]
),
FILTERS ( 'Tag Usage Fact'[Order Date] )
)
)If it still does not help, please provide your pbix file without privacy information and desired output.
Best regards!