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.
Hello All,
I am needing help to write a dax statment that will take the January Funded total (337) / total (1,876). Same applies for February funded total 918/1,876.
HI @reggiete ,
Can you please share some dummy data with the same data structure for test? It is hard to clear your table structure and code formula based on a snapshot of matrix visual.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
in the above matrix, i have the following measure in the values area
all dates or cross filter should help you
CALCULATE(COUNT(vw_PowerBIMainDataset[LoanNumber]),USERELATIONSHIP(vw_PowerBIMainDataset[LockDateCurrent],vw_PowerBICalendar[dtDate]),all(vw_PowerBIMainDataset[LockDateCurrent])))
or
CALCULATE(COUNT(vw_PowerBIMainDataset[LoanNumber]),crossfilter(vw_PowerBIMainDataset[LockDateCurrent],vw_PowerBICalendar[dtDate])))
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |