Help in set analysis

[Neha121]

Hi All,

 I have below data model filter on screen and a bar chart. My bar chart filters perfextly for FY year as its key in both tables. I want my bar chart to Filter when "Company" is selected. sum({< Company_MF = Company>}Total Value).. whats the right way of doing it.

Data Model

These are the filters on sheet 

Filter

FY Year

Company

Department

I have created the bar char with these fields

Bar chart

Gender_MF

sum(Total Value)

[PrashantSangle]

Do you need this for just one object or all dashboard??

if for all dashboard then create Composite Key in your data model 

in table 1

FY_Year&'_'&Company as key

in table 2

FY_Year&'_'&Company_MF as key

Regards,

[Vegar · Accepted solution]

You might be able to solve this using set modifier with set functions. Try this expression. 

sum({< Company_MF = P(Company)>}Total Value)

[Amit_Prajapati]

Hi @Neha121 ,

If you'd like the chart to display data only after a company is selected from the filter, you can use the following expression under Add-ons → Data Handling in the Calculation Condition field:

GetSelectedCount(Company) > 0

This ensures the chart remains hidden until at least one company is selected.

let me know if you need anything else or if your requirement is different.

[marcus_sommer]

IMO the data-model isn't suitable. Instead of keeping two fact-tables it would be better to concatenate them by harmonizing all field-names and data-structures as much as possible and adding an extra source-field which enables the possibility to differentiate between the sources in dimensions/selections/conditions.