Slicer not affecting the measure result

[as1195]

Hello,

I have a scenario where I have 2 helper tables (Level 1 and Level 2 tables) which is not connected to any table in the model.And in of the measure I am trying to find the total for every country and category combination based on logical condition as below.

Measure 1=
IF(AND[condition1],[condition2]),1)

Total Number=
           var a=summarize(fact table,fact table [country],fact table [category])
          return
           COALESCE( COALESCE(COUNTX(a, [Measure 1]), 0), 0)

Now the business requirement to have this Total number change as per the level selected in slicers.

For ex;
If user selects Sub Category (from Level 2 table) and Continent (From level 1 table)
then total number should also be dynamic.
Please note the the connection which is being used is live hence if there is any way I can achieve this by dax .Please let me know.That would be very helpful

Sample Model:

Thanks in advance.

[v-yadongf-msft]

Hi @as1195 ,

Since you don't create relationship between Level 1 and Level 2 tables and other tables, the slicer can't filter by Sub Category (from Level 2 table) and Continent (From level 1 table).

So please try to create relationships between Level 1 and Level 2 tables and other tables.

At the same time, since your data connection mode is live connection, you can't create relationships in Power BI, you need to go back to the data source to create relationships.

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.