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.
Hey,
i have a problem with my measure. I try to use Countrows on a table based on two columns in a related table.
I have a table "Receipts" (Many-side) and a table "Customers" (One-side) and they are in a Many-to-One relationship. So each receipt record has a column with a CustomerNo that has one record in my table Customer. Now I want to calculate the numer of receipts that meet the criteria of two columns in the related customer table.
For example I calculate the number of receipts that possess a customer number which has a address line like that:
Solved! Go to Solution.
@PowerFabian , Try a meausre like
Number with any phonenumber = CALCULATE(COUNTROWS(Fact_Belege), filter(Dim_Customer,not(isblank(Dim_Customer[FonPrivate1])) || not(isblank(Dim_Customer[MobileFonPrivate]))))
Yes, known thing for CALCULATE as it's implicitly using FILTER which pulls logic values from one column: for solutions refer to this: https://www.sqlbi.com/articles/filter-arguments-in-calculate/
@PowerFabian , Try a meausre like
Number with any phonenumber = CALCULATE(COUNTROWS(Fact_Belege), filter(Dim_Customer,not(isblank(Dim_Customer[FonPrivate1])) || not(isblank(Dim_Customer[MobileFonPrivate]))))
Thank you very much for your help. It worked like that for me.
Regards,
Fabian
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |