DAX - FILTER ALL based on the other measure

[Anonymous]

Hi,

I have a Power BI report based on the Tabular SSAS.

There is the following dimenstion table:

ColumnA  | Column B              

Europe      | E

Asia          |  A

America    |  A

America    |  AT

Report has only one slicer (ColumnA).

I need to create a measure based on the fact table which works according to the following:

• If I select value in the slicer calculate value based on the Column B ( select America which has (A, AT) display value for Asia and America because Asia has also 'A' in the Column B).

Measure works fine :

Measure 2 = CALCULATE(Measure 1,

FILTER(ALL('Table'), 'Table'[Column B] IN VALUES('Table'[Column B])))

The issue is that I would like to set additional filter on the column B and calculate only for those values when the other measure is greater or equal 1.

I've tried but it does not work:

Measure2 = CALCULATE(Measure1,

FILTER(ALL('Table'), 'Table'[Column B] IN VALUES('Table'[Column B])&& Measure3>=1))

[amitchandak · Accepted solution]

@Anonymous , Try like

Measure2 = CALCULATE(Measure1,
FILTER(VALUES('Table'[Column B]), [Measure3]>=1))

or

Measure2 = CALCULATE(Measure1,
FILTER(VALUES('Table'[Column B]), [Measure3]>=1), All(Table) )

I am not sure on the need of 'Table'[Column B] IN VALUES('Table'[Column B])  , from same table

[Anonymous]

Thanks a lot, it works ! 🙂