Forum Discussion

v-easonf-msft's avatar
v-easonf-msft
Community Support
3 years ago

Hi, Walt 

Are you currently using a hierarchy slicer? What do 'single data type' refer to?

Please share a sample .pbix for further research.

Best Regards,
Community Support Team _ Eason

Walt's avatar
Walt
Frequent Visitor
3 years ago

Yes, they are Hierarchy Slicers.
Single Data types like in the examples, 1Type 2Type and so on.
Here is another Example:
Slicer 1 I select..
From in Parent 1
in Group 2
1Type it has a value of 10

Then Slicer 2 Select 2 Types
From Parent 2
in Group 2
3Type with a value of 20
and
4Type with a value of 30

I would like to be able to compare the 1 selected type in Slicer 1 to the 2 selected types in Slicer 2.
So I could say... AVG the Slicer 2 Values to 25 or I could Sum them to 50 then compare them to the Slicer 1 Value of 10. 
SUM(Slicer2) / SUM (Slicer1) or Average(Slicer2)/Average(Slicer1) or Average(Slicer2)/SUM(Slicer1)

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    3 years ago

    Hi, Walt 

    Still just confused by part of your explanation, whether your slicer is multi-select or not, the final result should be aggregated.

    Do aggregation operations like sum and average of fields in the table work in your case?

    Measure2 = Average(Slicer2[Value])/SUM(Slicer1[Value])

     

    Best Regards,
    Community Support Team _ Eason

    • Walt's avatar
      Walt
      Frequent Visitor
      3 years ago

      Looking at your Example.  I am trying to accomplish something different.  I have a it setup as 3 seperate Tables.  The Parent, Type, and Group are identical.  Should I be doing something else?

      Slicer1(Created with Dax):
      - Parent
      - Type
      - Group
      Slicer2(Created with Dax):
      - Parent
      - Type
      - Group

      DataValues (Data Source):
      - Parent
      - Type
      - Group
      - Values