Need Help With Dax Calculation

[reggiete]

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.

[Anonymous]

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

[reggiete]

in the above matrix, i have the following measure in the values area

Locked = CALCULATE(COUNT(vw_PowerBIMainDataset[LoanNumber]),USERELATIONSHIP(vw_PowerBIMainDataset[LockDateCurrent],vw_PowerBICalendar[dtDate]))

[amitchandak]

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])))