From Tableau Fixed function to Power BI DaX

[ncbshiva]

Hi ,

I am trying to move my reports from Tableau to Power BI and i have some below LOD function which should be written in DAX.

Can any one please help to convert Tableau LOD to Power BI DAX ?

{FIXED
[Dstr Name],[Product description],YEAR([Day Date]), MONTH([Day Date])
:
COUNTD(
IF
[Fulls (Crates or Hl)]>0
THEN
[Product description]
END
)

}

[ncbshiva]

Hello,

Can anyone help me to convert from Tableau LOD to DAX .

FIXED
[Dstr Name],[Product description],YEAR([Day Date]), MONTH([Day Date])
:
COUNTD(
IF
[Fulls (Crates or Hl)]>0
THEN
[Product description]
END
)

[AkhilAshok · Accepted solution]

How about this:

-> Add 2 new column to the table:

Year = YEAR('Table'[day_date])
Month = MONTH('Table'[day_date])

-> Create a measure as below:

Measure =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Product Description] ),
    'Table'[Full(Crates & HL)] > 0,
    ALL ( 'Table'[day_date] ),
    SUMMARIZE (
        'Table',
        'Table'[Dstr Name],
        'Table'[Product description],
        'Table'[Year],
        'Table'[Month]
    )
)

[v-frfei-msft]

Hi @ncbshiva,

Kindly share your sample data and excepted result to me.

Regards,

Frank

[ncbshiva]

Dstr Name	Product Description	day_date	Full(Crates & HL)
A	Cola	14-9-2017	28989
A	Pepsi	21-8-2018	765
B	Fanta	1-4-2018	631
B	Amstel	5-12-2017	7633

Hi This is just the sample data , 

[v-frfei-msft]

Hi @ncbshiva,

To use this measure.

Measure = CALCULATE(DISTINCTCOUNT(Table1[Product Description]),FILTER(Table1,Table1[Full(Crates & HL)]>0))

For more details, please check the pbix as attacched.

Regards,

Frank

[ncbshiva]

Hi Frank ,

Thanks for ur reply, i got the distinct count number . But they have used FIXED LOD calcualtions in Tableau.

How can i use the same in Power BI DAX ?