Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a data with two column as date and other column as value but when I filter first column date I need to get that sum and when I filter second column date I need to get the sum of that with respect to column names. So the Kpi needs to work as a optional either this sum or that sum. Please check and reply asap.
can you try by using pick and match
No , Not working
Count({<[VIN]>}[Month of VP Report date]) - this is my set analysis when i filter vp report date column it should use this formula.
or
Count({<[VIN]>}[Month of prod date]) - this is my second set analysis when I filter Month of prod date formula it should use this formula.
If(getselectedcount(date1)>1, measure1,
If(getselectedcount (date2) >1, measure2))