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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
MrBrownn
Frequent Visitor

Repeat the result of measure filtring only by Year/Month

Hello everyobody,

 

I have 2 tables, billing and details,
Billing corresponds to invoicing per month by type of treatment (Tax_Id)

In the detail table, I have the details for each company.
The aim is to have a result as follows

Slicer (year=2023),
Filter on all the page tax_Id = 6

Result =

Company345
Etab1 160250
Etab230  
Etab3  250

 

Here is the PBI

=> Exemple <=

 

I want the mix of the 2 measures i created haha (test1, test2)

Thanks for your help in advance.

1 ACCEPTED SOLUTION
MrBrownn
Frequent Visitor

With a RELATED() Fonction, and using the same measure : 

 

Measure = VAR NbEtabs = CALCULATE(DISTINCTCOUNT(Etab), ALL(Etab)) VAR Montant = MAX('Operations DTCC'[RELATED(COLUMN)]) RETURN DIVIDE(Montant, NbEtabs)

 

My result is correct !

View solution in original post

5 REPLIES 5
MrBrownn
Frequent Visitor

With a RELATED() Fonction, and using the same measure : 

 

Measure = VAR NbEtabs = CALCULATE(DISTINCTCOUNT(Etab), ALL(Etab)) VAR Montant = MAX('Operations DTCC'[RELATED(COLUMN)]) RETURN DIVIDE(Montant, NbEtabs)

 

My result is correct !

selimovd
Super User
Super User

Hey @MrBrownn ,

 

what do you mean with "mix of the 2 measures"?
I also can't download the file:

selimovd_0-1691418584638.png

 

Best regards

Denis

 

Hello @selimovd 

ho sorry, i updated my post for the pbix.

what I mean is : for the measure test1 : the display is correct but not the values.

on the other hand, the values of test2 is correct but not the display. 

so i want the display of "Test1" and the values of "test2" 🙂

Your file is still not downloadable...

this time it's the good one ! sorry about that 

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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