Forum Discussion

Long's avatar
Long
Frequent Visitor
9 years ago
Solved

Relations between tables with measure column

Hi everyone,   Could you help to understand the following behavior and how to deal with this: I have a simple structure with one fact table and two dimensions with both direction relations:   ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Long,

     

    You can try to use below formula to calculate with the slicer, it not affected with the static value measure.

     

    BKFCPercent = 
var bigTotal = SUMX(ALLSELECTED(FactTable),[BKFC])
return 
divide(sum(FactTable[BKFC]), bigTotal)

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Long,

 

Can you please provide the pbix file to test?

 

Regards,

Xiaoxin Sheng

Long's avatar
Long
Frequent Visitor
9 years ago

HI Anonymous

 

You can download it here: TestReport.pbix

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Long,

     

    You can try to use below formula to calculate with the slicer, it not affected with the static value measure.

     

    BKFCPercent = 
var bigTotal = SUMX(ALLSELECTED(FactTable),[BKFC])
return 
divide(sum(FactTable[BKFC]), bigTotal)

     

    Regards,

    Xiaoxin Sheng