Forum Discussion

kylee_anne's avatar
kylee_anne
Icon for Helper II rankHelper II
9 months ago
Solved

Parameters and DAX

Hi Everyone,   So is always the way it seems, I wrote some horrid clunky DAX as I was in a hurry.  This is an example.   CP_P6 Budgeted Units = CALCULATE(SUM('Resource B'[Value]),'Resource B'[Sp...
  • kylee_anne's avatar
    kylee_anne
    9 months ago

    Nope I put in parameter as a field not in a slicer, created a table using it with M and then could use it in DAX.  

kylee_anne's avatar
kylee_anne
Icon for Helper II rankHelper II
9 months ago

Is it not possible to just use parameters?

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
9 months ago

kylee_anne , Parameter means slicer here. If you are calling URL you can pass the parameters. You can reduce measures using Calculation groups 

Service URL, when you call a report-https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

You need to have slicers or filters. 

We have a dynamic M parameter for direct query- https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

We can have a calculation group to rescue measures- Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0