create DAX for exclude LOD in tableau

[Meera556]

Hi,

I'm new to power bi and I'm replicating a dashboard from tableau to power bi.It is a heat map which contains the calculated field as {EXCLUDE [timestamp] : [count of errors]}

I need this is to be created in power bi. Can anyone help how to create this.

Thanks for your help in advance

[amitchandak · Accepted solution]

@Meera556 , Try like

a new measure assuming count of errors is a measure

calculate([count of errors], removefilters(Table[timestamp]))

Tableau Vs Power BI- Chapter 16- LOD exclude (Level of Details): https://youtu.be/wJEjG3O3vrk

[Uzi2019 · Accepted solution]

Hi @Meera556 

I think if you have [count of error] as measure then you just need to create a measure excluding timestamp

measure 1: Count( table[error])
measure 2= CALCULATE(Measure1, ALL( timestamp))

I hope I answered your question!

[amitchandak · Accepted solution]

@Meera556 , Try like

a new measure assuming count of errors is a measure

calculate([count of errors], removefilters(Table[timestamp]))

Tableau Vs Power BI- Chapter 16- LOD exclude (Level of Details): https://youtu.be/wJEjG3O3vrk