Forum Discussion

Greenwoodr's avatar
Greenwoodr
Icon for Helper I rankHelper I
7 years ago
Solved

measure values same on each row

Hi,    I have an issue around the context of calculated measures which I am struggling to get my head around.   I have the following   1. Fact table (sales)     Customer ID     Date ID     P...
Need Help
Show and Tell
Tips and Tricks
  • Greenwoodr's avatar
    Greenwoodr
    7 years ago

    Hi,

     

    I have been playing and Cross directional filtering on the customer table seems to give me the right answer.

    Thanks for your time

     

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
7 years ago

Greenwoodr

 

CALCULATE function needs to be used in combination with a FILTER or All/Allexcept/Allselected function.

 

Any chance to share the file with us or send us some sample data and the expected output?

 

e.g.

PhoneNumberFlag = calculate(sum('Customer table'[PhoneNumberFlag]), ALLEXCEPT('Seller Table', 'Seller Table'[Seller Name]))
Greenwoodr's avatar
Greenwoodr
Icon for Helper I rankHelper I
7 years ago

Thanks. 

 

I have recreated the problem and put the tables data in Excel - what is the best way to share it?

Richard

  • themistoklis's avatar
    themistoklis
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Greenwoodr

     

    You can use dropbox, onedrive, googledrive,.... or e.g. wetransfer.com

    • Greenwoodr's avatar
      Greenwoodr
      Icon for Helper I rankHelper I
      7 years ago

      I have put some screen shots of the problem if that helps.