Forum Discussion

nikkr38's avatar
nikkr38
New Member
2 years ago

Total not visible in Table

Hi everyone,  I have a issue, where values are shown on row level but not at the total level. Logic for the calculation has to be as followed: 1. We have to check Billings for the previous mon...
"DAX"
"Power BI"
"Totals"
Last date
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  nikkr38 ,

 

Here are the steps you can follow：

1. Create measure.

Measure =
var _maxdate=
MAXX(
    ALLSELECTED('Table'),'Table'[Date])
var _value=
SUMX(
    FILTER(ALLSELECTED('Table'),'Table'[Date]=_maxdate),[Net Billings])
RETURN
IF(
    _value<>0&&HASONEFILTER('Table'[Date]),SUM('Table'[Internal Cost]),
    SUMX(
       FILTER( ALLSELECTED('Table'),[Net Billings]<>0),[Internal Cost]))

2. Result:

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

nikkr38's avatar
nikkr38
New Member
2 years ago

Hey Anonymous 

I appreciate your efforts in solving this problem, but the soltuion is not correct.
I need only the sum of cost, after the most recent date when there was a value in Billings & if there is no value in billings for previous month then I need sum of all the internal cost.

FYI : Date has to be most recent when there was a value in Billing for previous months.

Let me know if you need, more info.

Thanks,
Nik