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

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