Forum Discussion

justinMcC's avatar
justinMcC
Frequent Visitor
8 years ago
Solved

Filter data using slicer (1 table to another)

Hi    I have a report that I need the end user to be able to categorise a 'holding' on my 'holdings table' as either beef or dairy based on a percent using a visual filter, eg slicer. The filter is...
Need Help
  • mehaboob557's avatar
    mehaboob557
    8 years ago

    Hi justinMcC,

     

    Create 2 Measures to achieve this ac below.

     

    Measure 1:

     

    Calculate Dairy % = CALCULATE(SUMX(your_table_name, your_table_name[PERCENT_DAIRY]),ALLEXCEPT(your_table_name, your_table_name[HOLDINGID]))

    Measure 2:

     

    Category = IF([Calculate Dairy %] >= 80, "DAIRY","BEEF")

     

    Please give a kudo and Accept the soultion if it works for you.

     

    Thanks,

    Mehbub- India

justinMcC's avatar
justinMcC
Frequent Visitor
8 years ago

Hi mehaboob557

 

Thanks for all your help, your solution worked

 

The next step I have however is to create a chart from the results, ie Beef = 4, Dairy = 4, however I cant use a measure is a chart

 

Do you know how to turn a measure into a column?

 

Again thank you for the above, your help was much appreciated

mehaboob557's avatar
mehaboob557
Resolver III
8 years ago

Show me some output how you need.

 

If possible create a new forum post and send me the link . I will check and if possible i will help