Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Ignore row context when using dimension table as slicer

Hi

I have a fact table which calculates the "GCA" -measure and I have a dimensions table for the field "Exposure".

In the data model the relationship between both "Exposure" fields is established.

Assume there is another table connected with the "Exposure"-field of the dimensions table (not shown here).

The "Exposure" -field from the dimensions table is shown in the row context.

"GCA" is as follows:

 

GCA:=CALCULATE(SUM(tr_cre__3[Amount]);FILTER(tr_cre__3;tr_cre__3[Perf_Status]=0))

 

I am having trouble to write a measure that

  • ignores the row context (on the dimensions table?)
  • keeps the Filter on Perf_Status and the "Lable"-Filter

Goal is th show 321.011 left to the GCA measure.

Something like this only works when I use "Exposure" from the fact table:

 

GCA_ALL:=CALCULATE(SUM(tr_cre__3[Amount]); ALL(tr_cre__3[Exposure]);tr_cre__3[Perf_Status]=0)

 

But then, one cannot use the dimensions table on "Exposure" as slicer.

Any help is appreciated.

 

 

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello v-xuding-msft 

      thank you for your answer and please excuse my delayed response.

      I'm not sure, if your answer is the way to do it, if so, it is cumbersome when building a data model.

      Further information:

      The model shows following situation:

       

      And the pivot table with GCA_ALL2 showing a lifted filter on Exposure.

      with this:

      But this works only with the "Exposure" field of "tr_cre___3".

       

      But I cannot use this field as slicer for the other table in order to bring the information from "tbl_Dep".

      And "GCA_ALL2" does not look ok, if I pull in the rng_Exposure- Exposure:

      I sounds odd to create a disconnected table for every connected table combination.

      Thanks for your insight.