Post reply

DAX Starter question

  • September 1, 2017 at 12:16 pm

    #150648

    Hello,

    I am trying to figure out out to work this out in DAX, played a bit with ISFILTERED() but doesn't seem to help or I am going about this the wrong way.

    I have the following table I want to reproduce:

    Surface Area
    STORE A 1306

        SALES TYPE A

    		 1306

        SALES TYPE B

    		 1306
    STORE B 1457

        SALES TYPE A

    		 1457

        SALES TYPE B

    		 1457
    STORE C 1003

        SALES TYPE A

    		 1003
    Grand Total 3766

    In yellow are my expected amounts.
    I have the Surface Area at the Store level and it is propagated at the Sales type Level in the fact table, which is the lowest grain, I need to sum the surface areawithout being counted multiple times at the Store total and Grand Total.

    What should be the DAX formula to calculate the Surface Area ?

    Thanks,

  • September 1, 2017 at 1:16 pm

    #1957888

    I did that with Store table (contains Surface Area), and Sales. I created a Total Surface Area measure = SUM(Store[SurfaceArea]) and put Store and SalesType on Rows, and Total Surface Area on Values.

    Surface Area isn't in the Sales table, so it should calculate fine... Or is there something I am missing?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply