Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
snifer
Post Patron
Post Patron

matrix issue

     real result  
         
 januar februarmarch  januar februarmarch
code123 code111

 

basicaly i need to count homeany time happen a code in a month

in this exa,ple i say is happen 1 time month

so i should have as result like in inthe right 

for every month all 1

but instead i got result as left

it s make the sum of every month progressive,

how i cna display just the count for a single month

?

3 REPLIES 3
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @snifer,

 

From your information, it seems that the result in right is your desired and the result in left is your current result?

 

If it is, could you share your data sample so that I can help you create the correct matrix?

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

From your information, it seems that the result in right is your desired and the result in left is your current result?

YES

@v-piga-msft

 

right i cant paste and example can you try to use the one i posted?

Hi @snifer,

 

From my understand, you posted is your result output not the data sample?

 

You just share your dummy data  sample which could reproduce your scenario then I could copy and test on it.

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.