How to SUMMARIZE with Filter/Condition using Dax in PowerBI | MiTutorials

Sdílet
Vložit
  • čas přidán 28. 03. 2022
  • How to SUMMARIZE with Filter/Condition using Dax in PowerBI | MiTutorials

Komentáře • 21

  • @jamesdeanstephens
    @jamesdeanstephens Před rokem

    Love the step-by-step process you went through. Thanks.

  • @julie_chen
    @julie_chen Před 2 lety

    Thank you. Added to my watch list.🙏👍

  • @tonianibal7585
    @tonianibal7585 Před rokem

    Perfect, thank you ! धन्यवाद भाई

  • @skdonsingh
    @skdonsingh Před rokem

    Nice explanation brother.Thank you very much for your video ❤

  • @timothytim1053
    @timothytim1053 Před rokem

    Can you filter a connected date table in the same way? Would 2 filters work?

  • @leticiacardoso252
    @leticiacardoso252 Před 2 lety

    Thank you!!!

  • @AndresTorres-fr5ui
    @AndresTorres-fr5ui Před rokem

    Tks, its posible tu use more than one criteria in the filters?

  • @pratapchitdumrongsakul2167

    Thank you.
    🙂

  • @growlife4779
    @growlife4779 Před 2 měsíci

    can I see your measure for total sales please? when I use sum it just inflates everything

  • @sr5726
    @sr5726 Před rokem +1

    if table is what we need we can use
    summarizecolumns instead of summarize+filter (
    addcolumns+summarize+filter would have been more appropriate)

  • @sopauljauck4163
    @sopauljauck4163 Před rokem

    I stumbled to your channel as I am searching for ways to advance my power bi skill. Sub.

    • @MITutorials
      @MITutorials  Před rokem

      All the best ! Hope you learn BI through my videos.

  • @user-jj3xl4nt1u
    @user-jj3xl4nt1u Před 8 měsíci

    Create a new summarize table with selected columns (region, country, sum of sales) from the global superstore and filter the region based on the given conditions, Central Asia, North, South & East. make video on this . please . or tell me how to get filter this
    four region

  • @104_muhammadhaikalrahman4
    @104_muhammadhaikalrahman4 Před 5 měsíci

    My struggle when making summary table it cant filter with slicer by field from other table anyone please help me

  • @sumerakhan3412
    @sumerakhan3412 Před rokem

    how you get [ total sales] measure?

    • @MITutorials
      @MITutorials  Před rokem

      Total_Sales = CALCULATE(SUM(Your_Sales_column))

    • @sumerakhan3412
      @sumerakhan3412 Před rokem

      @@MITutorials Means you had calculated it before?

  • @jayantmishra4270
    @jayantmishra4270 Před rokem

    Hi...
    Can you help me to solve this question ??
    Which of the following DAX function will return a table :-
    1 SUMMARIZECOLUMNS
    2 CALCULATETABL
    3 RELATEDTABLE
    4 All of the above
    5 None of the above
    Please answer the question??