Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Pham Trinh]

Hi, 
I have a poblem. 
When I choose the Number of Transaction, only the change in the 1st chart, but there was no change in the 2nd chart according to the 1st chart.
Due to PowerBI don’t support filter in measure. But “NumberOfTransaction” is measure, so I read
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=c78f7a0c-5fa4-40c9-896a-d161eaa9449e&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer#bmc78f7a0c-5fa4-40c9-896a-d161eaa9449e%C2%A0
And I created filter measure. But When I choose the Number of Transaction, only the change in the 1st chart, but there was no change in the 2nd chart according to the 1st chart.

Expect Result when I Choose NumberOfTransaction = 1

Expect Result when I choose NumberOfTransaction = 4

(( file power bi attach ))

——————————
Pham Trinh
979319896
——————————

[Aurelien BETBEUI KWANDJEU]

Hello Pham,

If you have seen what you have done, you should also add the “Sales Filter” indicator in the “Element Level Filters” session of your second table.
This one is present for table 1.

Once you have added the filter it will be necessary to rework the formula of the indicator “Sales Filter”.

Regards,

——————————
Aurelien BETBEUI KWANDJEU
CHIEF DATA OFFICER (BI & DWH)
0033766857584
——————————
——————————————-

[Pham Trinh]

Hi Aurelien , 

I’m a Power BI beginner, can you help me with the keyword to solve this problem?
Thank you very much !

——————————
Pham Trinh
979319896
——————————
——————————————-

[Hasham Niaz]

Hi Pham,

It is easier to solve the problem through Data Modelling rather than DAX, i have done following to solve it;

1) Create a Summarize table [TransactionSummary] with 2 columns [CustomerNumber], [NoOfTransaction], use below DAX;

TransactionSummary = SUMMARIZE(TransactionInformation 
      , CustomerInformation[CustomerNumber], "NoOfTransaction", COUNT(TransactionInformation[CustomerNumber])
      ) ?

2) Create another table using Data entry option & provide [NoOfTrans] from [0-10] this could be dynamic as well;
3) Create following relationships;

[CustomerInfomation] -> [TransactionSummary] (1 to 1) based on [CustomerNumber], set cross filter direction to [Both]
[CustomerInfomation] -> [TransactionInformation] (1 to Many) based on [CustomerNumber], set cross filter direction to [Single]
[NoOfTrans] -> [TransactionSummary] (1 to Many) based on [NoOfTransaction], set cross filter direction to [Single]

4) Now place a slicer filter from [NoOfTrans] table & it will do the magic of filtering both of your visuals.

Attached is the .pbix file for your reference.

Regards,

——————————
Hasham Bin Niaz
Sr. BI Consultant
Karachi, Pakistan
——————————
——————————————-

[Pham Trinh]

No , I create NumberOfTransaction with “measure” , not “column”. Because If I created slicer filter Restaurant , so it is fail with “column”.
So I want solotion with “measure”
Thanks Hasham

——————————
Pham Trinh
979319896
——————————
——————————————-

[Hasham Niaz]

Please describe your requirements more clearly;

You need to filter based on [Restaurant Code] as well meaning when you pick any [Restaurant Code] & chose [NoOfTransaction] so it will need to filter based on both right.

Suppose [Customer2] has 4 transactions in all, 1 transaction at each restaurant, so when you choose [Rest2] and [NoOfTransaction] = 2, then [Customer2] should not be shown.

Regards,

——————————
Hasham Bin Niaz
Director Data & Analytics
Karachi, Pakistan
——————————
——————————————-