Forum Discussion

jahlum1's avatar
jahlum1
New Member
10 months ago
Solved

Calculation using distinct counts form two different matrix tables

I have two separate matrix tables with the data below -   Matrix 1: Week of the Year [YRWK] a record was completed Count of records completed during each YRWK [Count of TD_comp]   Matrix 2: We...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    10 months ago

    Hi,

    I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

     

     

     

     

v-achippa's avatar
v-achippa
Community Support
10 months ago

Hi jahlum1,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you AmiraBedh, Jihwan_Kim and Bmejia for the prompt response. 

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
10 months ago

Hi @jahlum1,

 

We wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa