Help on Data Model

Power BI Data Model
1

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.

image
image1069Ă—422 15.1 KB

image
image1096Ă—485 12.1 KB

Percent_Test.pbix (47.9 KB)

2

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.

image
image601Ă—589 18.4 KB

Kind regards JW

3

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.

image
image1104Ă—464 16.2 KB

image
image1086Ă—415 13.6 KB

Percent_Test.pbix (48.1 KB)

4

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:

image
image820Ă—474 9.26 KB

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

1 Like
5

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.

6

@Anurag

Thanks a lot Anurag :grinning: