This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELD%3C/text%3E%3C/svg%3E)
Hi
I am trying to replicate one of the measures created in SAP BO to tabular model using DAX. Below is the existing measure formula
=Count([A]) In ('Table'.[B];'Table'.[C];'Table'[Calculated Column1]) Where ([Flag] = "30 Days")
How should I replicate the same using DAX
Please advise
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Hi @Learner DAX
Not quite familiar with SAP BI, could you explain what is the expected results of this expression?
Hi @Lukas Yu -MSFT
Thanks for the response.
The goal of the measure is to show Count of values from ColumnA when "30 Days" filter is applied on ColumnB, ColumnC and CalculatedColumn1.
Hi,
Did you mean count the rows of table if ColumnB, ColumnC and CalculatedColumn1 all equal to "30 Days" ?
IF so,
=CALCULATE(COUNTROWS(Table),FILTER(Table,Table[ColumnB]="30 Days" & Table[ColumnC]="30 Days" & Table[CalculatedColumn1]="30 Days"))
Hi,
Did this fit your need?
Have you resolve your issue ?