Forum Discussion

ANMOLVK's avatar
ANMOLVK
New Member
3 years ago

Question on DAX

Hi everyone,

I need your help.

I have a model which has multiple tables. I'm trying to create a calculation which basically takes 3-4 dimensions from different tables, and filters on a measure if it's greater than one.

To give more context:

I have 4 dimensions : Release, Package, Application, Test which come from different tables.

I need to find the number of unique tests at this level (4 dimensions mentioned above).

so it should say:

Release 1, Package 1, App 1, Test 1   ----- 20 tests

Release 1, Package 1, App 1, Test 2.  ----- 25 tests......

 

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    ANMOLVK So, can you just put each of those columns in a Table visual with a simple COUNTROWS of your fact table?