Forum Discussion

Greenwoodr's avatar
Greenwoodr
Helper 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
Community 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
    Helper 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
      Community Champion
      7 years ago

      Greenwoodr

       

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

      • Greenwoodr's avatar
        Greenwoodr
        Helper I
        7 years ago

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

  • Greenwoodr's avatar
    Greenwoodr
    Helper I
    7 years ago

    Fact TableOther TablesOther TablesBI DesignActual OutputIDesired Output

  • Greenwoodr's avatar
    Greenwoodr
    Helper I
    7 years ago

    Fact TableOther TablesOther TablesBI DesignActual OutputIDesired Output

    • Greenwoodr's avatar
      Greenwoodr
      Helper I
      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

       

    • Greenwoodr's avatar
      Greenwoodr
      Helper I
      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