Help on Data Model

Hello,

I want to use a single filter dropdown which filter both table correctly but am unable to achieve the same, am unable to figure out a right model for this.

I have attached the PBIX file for your reference.

Any help is appreciated.



Percent_Test.pbix (47.9 KB)

Hi @Dharma,

Would a single slicer, with two dimensions ( Country and Hired Form) helps you any further ?
If I misunderstood your question, could you explain your question more ?

See PBIX :
Percent_Test (4).pbix (48.1 KB)

Data model:
The slicer chooses Fact-table dimensions directly, it is possible to create two separate lookup tables for “Country” and “Hired from”
The table “Key filter” is not needed.

Kind regards JW

Hello @deltaselect

Thank you for your reply.

Let me put my concern in simpler way.

  1. The reason I created key filter because I want a Table visual which can be filtered by Column name selection like Country or Hired From in Table 1.

Problem is
I want a single filter for example country which filters both Table1 (which is using key filter) and Table 2 (which uses any attribute from data table).

In the below case am not able to get the same.



Percent_Test.pbix (48.1 KB)

Hi,

Dharama just replace the your measure with the below measure it will give you correct answer :

Combined Values =
VAR Total_Values = [Total values]

VAR Percent_Values = 
   
        DIVIDE(
            COUNTROWS('Data Table'), 
                CALCULATE(
                        COUNTROWS('Data Table'), 
                             ALL('Data Table')),
     0)
Var ans=   Total_Values&"("&FORMAT(Percent_Values,"Percent")&")"  
Return
if (ISBLANK(Percent_Values),BLANK(),ans)


--Total_Values





As you can see in the below screenshot:

For your reference i am attaching the pbix:
Percent_Test_solve.pbix (48.7 KB)

1 Like

Hi @Dharma , did the response provided above help you solve your query?

If not, how far did you get and what kind of help you need further?

If yes, kindly mark as solution the answer that solved your query.

@Anurag

Thanks a lot Anurag :grinning: