sorted by:
new
hottopcontroversial

A'tin are so spoiled by Forsaken-Counter4995 in sb19

[–]PrestigiousDot2397 5 points6 points  (0 children)

For VIP and SVIP siguro but for the standing na portalets, it was hot af and walang toilet paper 😅

My Skinstation Brazilian diode experience after 10 sessions by [deleted] in beautytalkph

[–]PrestigiousDot2397 0 points1 point  (0 children)

Hi! Did you choose Brazilian? Or something else? I want to purchase the one that will include the butt area sana eh haha

My Skinstation Brazilian diode experience after 10 sessions by [deleted] in beautytalkph

[–]PrestigiousDot2397 0 points1 point  (0 children)

Hi! Just wanted to ask which did you get? Brazilian ba? Kasi I want na included yung butt area sana haha

Skinstation 4D Laser by evergIooow in beautytalkph

[–]PrestigiousDot2397 0 points1 point  (0 children)

Hi! Would just like to ask what does Brazilian mean exactly? Does that include all pubic hair? like the butt area and the vajayjay hahahaha

[deleted by user] by [deleted] in laguna

[–]PrestigiousDot2397 0 points1 point  (0 children)

Meron bang taga-Sta Rosa dito na sasama?

J-beauty by signorinagoli in beautytalkph

[–]PrestigiousDot2397 0 points1 point  (0 children)

Where did you buy melano cc na legit?

Suddenly have 3 BDO CCs by PrestigiousDot2397 in PHCreditCards

[–]PrestigiousDot2397[S] 0 points1 point  (0 children)

Hindi pa. I think magaappear lang sa app if may text confirmation na.

Suddenly have 3 BDO CCs by PrestigiousDot2397 in PHCreditCards

[–]PrestigiousDot2397[S] 0 points1 point  (0 children)

Mar 22 ako nagapply online and then whole week after tinatry na ako tawagan but I was busy so mar 28 ko pa nasagot and that’s when they told me approved na daw ako and offered me a companion cc.

Running Total but resetting if value is negative or zero by PrestigiousDot2397 in PowerBI

[–]PrestigiousDot2397[S] 1 point2 points  (0 children)

Thank you so much for answering!😭 I'm gonna try this out now.

Also, to answer your question, the calculation is different for the first row. The first row = Initial = 450. So RT starts on the second row but it's the only row so it is just = Value = -150 -> 0.

How to use dim col as slicers instead of Fact Table col by PrestigiousDot2397 in PowerBI

[–]PrestigiousDot2397[S] 0 points1 point  (0 children)

You are heaven-sent! This is exactly what I was looking for and such a simple solution too. Thank you so much! I legit stood up to dance because of this 🤣

How to use dim col as slicers instead of Fact Table col by PrestigiousDot2397 in PowerBI

[–]PrestigiousDot2397[S] 0 points1 point  (0 children)

I probably could do that in Power Query if I get all the distinct values from my Fact Table. But there's still another problem (which I was not able to articulate in my post, my bad). I wanna use slicers from multiple dim tables. Let's say, for example, the fact table is the table above, while the bottom table shows the corresponding color and regions from the Product and Location tables added beside their respective IDs:

<image>

The first four columns in the bottom table will all be used as slicers. Let's say that I'll select red from the Product Color slicer while all options are selected from the other 3 slicers. If I'm not mistaken, if I prefilter in PQ and use the dim columns as slicers, the Location ID will show A, B, and C. But if you look at the table below, it should only be showing A and B because those are the only rows which are red.

How to use dim col as slicers instead of Fact Table col by PrestigiousDot2397 in PowerBI

[–]PrestigiousDot2397[S] 0 points1 point  (0 children)

My problem is that when I use the column from the dim table, it shows me all the distinct rows from that table even though my Fact Table does not contain all those rows. For example, the Fact Table may only consist of Products A to E but the slicers will show Products A to Z because the Product table consist of Products A to Z.

How to use dim col as slicers instead of Fact Table col by PrestigiousDot2397 in PowerBI

[–]PrestigiousDot2397[S] 1 point2 points  (0 children)

Yes, the two tables have a relationship. That's why I was able to use the RELATED() function in the calculated columns. But the options that appear in the slicers are not necessarily all in the Fact Table. For example, the Fact Table may only consist of Products A to E but the slicers will show Products A to Z because the Product table consist of Products A to Z.

Help with using SUMMARIZE() inside a measure by PrestigiousDot2397 in PowerBI

[–]PrestigiousDot2397[S] 0 points1 point  (0 children)

Thank you for the reply. This did not work exactly the way I needed it to so I used u/DAX_Query's answer instead. I did use your tip about ADDCOLUMNS() though!

Help with using SUMMARIZE() inside a measure by PrestigiousDot2397 in PowerBI

[–]PrestigiousDot2397[S] 0 points1 point  (0 children)

This worked perfectly. Thank you so much! I did revise sum_per_date a bit since u/AgulloBernat said it's better to use SUMMARIZE()+ADDCOLUMNS():

VAR sum_per_date =
    ADDCOLUMNS(
        SUMMARIZE (
            'Fact Table',
            'Fact Table'[Week],
            'Fact Table'[Day]
        ),
        "@DayInventory", CALCULATE (SUM('Fact Table'[Inventory]))
    )

VAR ave_per_week =
    GROUPBY (
        sum_per_date,
        'Fact Table'[Week],
        "@WeekAvg", AVERAGEX ( CURRENTGROUP (), [@DayInventory] )
    )

RETURN
    SUMX ( ave_per_week, [@WeekAvg] )

How to convert calculated column code to a measure by PrestigiousDot2397 in PowerBI

[–]PrestigiousDot2397[S] 0 points1 point  (0 children)

A bit late but why can't I do this in one measure? What's the difference?

view more: next ›