Forum Discussion

NavaneethaRaju's avatar
NavaneethaRaju
Helper IV
4 years ago
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 ...
Need Help
Show and Tell
Tips and Tricks
  • memepu's avatar
    memepu
    4 years ago

    Hi NavaneethaRaju ,

    I have only created a simple sample, please refer to it to see if it helps you.

    Need Help with Measure.pbix

    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.

     

memepu's avatar
memepu
Resolver II
4 years ago

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!

NavaneethaRaju's avatar
NavaneethaRaju
Helper IV
4 years ago

Hi memepu , 
Procedures fact is the seperate table, that table only have the procedure count.
Now i can share pbix or excel file with you. Please share any email and outlook mail id.